0

Hi All,

I need to create a macro that will copy the data in the last 5 columns of the spreadsheet and paste it to the next 5 columns, also I need to have a pop up that will let me add date to the heading of the new inserted columns.

EX:

C1 C2 C3 C4 C5 -----> I want to copy these five columns and insert them to
1/21/2011-->date in c3

D1 D2 D3 D4 D5, with new date 1/22/2011 in cell D3.

Thank you in advance.

2
Contributors
1
Reply
2
Views
7 Years
Discussion Span
Last Post by AndreRet
0

Have a look at This link to determine the next empty row.

Now have a look at This link which will copy and paste the values over.

The magic of Google.;)

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.