rdelosh74
07-29-2014, 07:09 AM
Need help please.
I need a macro that will take every sheet and make a new workbook the same name as the sheet for every sheet starting on the 5th sheet to the end. And to copy the contents of the original sheet to the new workbook.
So for instance if the sheets in the original workbook were numbered. 1 2 3 4 5 6 7 8 9 10 11 12 13.
I would end up with the original workbook. And the following workbooks:
5, 6, 7, 8, 9, 10, 11, 12, 13.
And the data in workbook 5 would be the same data as in the original workbook on sheet 5.
If that makes sense.
Thank you very much.
I need a macro that will take every sheet and make a new workbook the same name as the sheet for every sheet starting on the 5th sheet to the end. And to copy the contents of the original sheet to the new workbook.
So for instance if the sheets in the original workbook were numbered. 1 2 3 4 5 6 7 8 9 10 11 12 13.
I would end up with the original workbook. And the following workbooks:
5, 6, 7, 8, 9, 10, 11, 12, 13.
And the data in workbook 5 would be the same data as in the original workbook on sheet 5.
If that makes sense.
Thank you very much.