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.
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.