Hi all,
Hoping for some help, it would be greatly appreciated. I'm new to vba and my task at hand involves copying worksheets from multiple workbooks and pasting them into a new workbook with multiple sheets.
I have 12 workbooks to start with. Names Jan2006 thru Dec2006. Each workbook has about 50+ worksheets, named T01 thru T58.
What I would like to happen is to copy the range("C4:O58") of each worksheet, titled T01 from each workbook and paste them into a new workbook, to be named table01. So the new work book will be named table01, and have 12 work sheets, Jan, Feb, Mar... Dec.
Could I have some help with a template to get me started. If you need anymore details please let me know. I really appreciate. thank you
Bookmarks