Member Avatar for ichiban1985

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
  • 104 Views
  • 20 Hours Discussion Span
  • Latest Post Latest Post by AndreRet
Member Avatar for AndreRet

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.