Copy and paste data

[thedeadzeds]

Hi All,

This code basically copies data from one worksheet to another worksheet based on the date and works great. However, I have been asked to changed the format of the spreadhsete and the code needs to be changed. The code is in ‘This workbook’.

The code takes the data from the summary tab and copies it to the archive tab. I now need it to take it from the summary tab and copy it to the archive 2 tab.

Hope this makes sense, I have attached a copy of the spreadsheet.

Thanks

Please Login or Register  to view this content.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[thedeadzeds]

Many thanks, when I run the Macro it shows an overflow error

[millz]

Try:

Please Login or Register  to view this content.

[thedeadzeds]

it does work but I will need to add to the spreadsheet so I'm probably not going to be able to adapt this code to fit the new amendments. Is there any way of using the same format as the original code but slightly chnging it. The reason I as is that i can easier amend the original code but will probably not be able to do this on the new code. Sorry for any inconveniance

[millz]

I am not sure what problem you may face if you only want to add to the spreadsheet. I've added some comments to help you understand code in the previous post. Hope it helps.

[thedeadzeds]

thanks millz, I probably explained this really badly. I have uploaded a new spreasheet with new sections added in the summary tab and archive 2 tab (highlighted in green). These also need to be copied over so i need to understand how i can copy these over as well. The spreadsheet is constantly changing so i wll need to make ammendmens as and when. Hope this makes sense

[millz]

I see. Here you go:

Please Login or Register  to view this content.

[thedeadzeds]

works like a dream, many thanks