VBA for copy-paste cells and formulas with links to other WSheets

**nasia** · 08-31-2012, 06:55 AM

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

**arlu1201** · 08-31-2012, 06:59 AM

It will be good if you explain with the help of a sample file. Remove sensitive information.

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

**nasia** · 08-31-2012, 07:23 AM

I think I attached it. thanks for the walktrhough!

Now from the file below i want to create the next month (february) which will be a copy paste from January. But i may want to add some routes or AC in february so when i will create march i want o copy paste february and not january.

BOOK TEST NASIA.xlsx