adjust macro to perform same action -but over more columns
$30-250 NZD
Terminado
Publicado hace casi 13 años
$30-250 NZD
Pagado a la entrega
The MAX I expect to pay for this is $50.
Hi. I have a macro (See attached). It currently takes a spreadsheet with 4 columns (see [login to view URL]) and makes some changes. Basically those changes have to do with adjusting the first two columns to "match" the second two columns in terms of dates (actually not exactly "matching" as you can see if you run it).
The change I want is so that the second two columns can be expanded to any number of columns (say n) and have it do the same thing to all the columns from colunm4 to columnN.
More specifically:
column1 has a date and column2 has a number associated with that date
column3 has a date and column4 has a price associated with that data.
the macro aligns column3 (and moves the entries in column4 along with the entries in column3) so that basically the date in column1 precedes the date in column3 by 1 day (not exactly but that is the basic idea.)
It does this without disturbing the relationship between the data in column3 and column4
and also
without disturbing the relationship between the data in columns1 and columns2.
That is the current macro.
What I want, is to have more columns after column4 but in the same way that the current macro does not disturb the relationship between columns3 and columns4, I want the new macro not to disturb the relationship between column3, column4, column5, .... , columnN.
By the way, what I mean by "not disturb the relationship between two columns is that if in RowK the entries in column3 and column4 were originally xxx and yyy, then in the new (outputted sheet), whatever row has the xxx data in column3, will also have the yyy data in column4 (note it almost certainly will not now be RowK because row wise everything is being changed by the macro). Hope this is clear.
The MAX I expect to pay for this is $50.