hallo I am afraid I am a very new one and still trying to work my way through vba.... So I definately need your help
I have an excel sheet with multiple rows and columns as a set, updated every month from another workbook. they look like this:
month1
A B C .................
1 formula formula formula ..........
2 ........... ............. ..................
3........... ............. ..................
.
.
.
Each formula contains a link to another workbook.
I want to copy and past the above rows and column formulas to the next available (blank) rows. i want this to be done every month. But there are also two problems : 1) each time i want to copy the previous month 2) the rows and columns will not remain constant. ex month1 may have 12 rows and 20 columns and month 2 may have 15 rows. I am more conserned with rows since the columns are going to be inserted with insert column excel command to all months.
hope it is clear....
Bookmarks