In Progress

adjust macro to perform same action -but over more columns

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 [url removed, login to view]) 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.

Skills: Excel, Visual Basic

See more: same, perform, macro, macro excel, excel macro match data, excel macro row, xls visual basic, macro spreadsheet, excel match columns row, macro match excel, matching excel, excel data matching, match columns excel, excel data matching macro, match macro, almost basic, excel matching, columns excel, excel adjusting entries, entries spreadsheet, excel macro sheet, price matching data, excel price macro, everything excel, price excel macro

About the Employer:
( 53 reviews ) Beppu shi, Japan

Project ID: #1152768

Awarded to:


See PM please. Thanks, Svet.

$50 NZD in 1 day
(78 Reviews)

6 freelancers are bidding on average $47 for this job


Hello, Excel VBA expert here. Please check PM for details. Thanks!

$50 NZD in 2 days
(67 Reviews)

Hi, please see PM!

$40 NZD in 1 day
(30 Reviews)

Hi, please check your PM. Thank you.

$50 NZD in 1 day
(26 Reviews)

I will do it

$30 NZD in 2 days
(3 Reviews)

Hello, I can do this job.

$50 NZD in 2 days
(0 Reviews)

I am an Excel and VB expert. I can do it quickly and perfectly ...

$40 NZD in 1 day
(0 Reviews)