Copy 5 columns and paste to next 5 columns

Closed
ichiban85 - Jan 25, 2011 at 03:37 PM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jan 27, 2011 at 09:00 AM
Hello,

I have to run daily reports where I have to add new day data to the right end of the spreadsheet. Example is below. I want to create a macro that will automatically do that.

A1 B1 C1 D1 E1 I want to copy datas in the those 5 columns and paste to the right
: : : : :
A9 B9 C9 D9 E9

I want to copy datas in the those 5 columns and paste to the right end of the spreadsheet.

F1 G1 H1 I1 J1
: : : : :
F9 G9 H9 I9 J9

Next day will the the info above and copy to

K1 L1 M1 N1 O1
: : : : :
K9 L9 M9 N9 O9

Can someone help me with this. Thank you in advance.




Related:

1 reply

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Jan 27, 2011 at 09:00 AM
Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc
AND post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too.


Note:
your data need not be to be real data but a good representative of how data looks like
0