Copy and paste massive data

Hello!



Excel Marco is very new to me. I have some knowledge in VBA but nothing extensive. I have a massive data in excel that have 58+ worksheets.

We are in the process of doing our annual reviews, I have to run the excel report called Annual 12x’s and generate a workbook called Table1_2006 - Table58_2006, in each workbook it have 12worksheets called “Jan,Feb,March..etc”

Here is what I found and it seen to work but it copy the whole worksheet I only need to copy a range and text box (footnote) that I have, also my computer is super slow, is there a way to copy one workbook and close and open another workbook?

Please Login or Register  to view this content.

any help will be greatly greatly Greatly appreciated !

CThai

Thanks! I will give this a try and praying that it will work!