My excel book contains 435(named 1,2,3,4,5,....435) worksheets as the one attached. I need to save these worksheets as separate workbooks in a designated folder after a simple copy pasting action.
Stage 1: Create a copy of the worksheet in the same workbook
Stage 2: Copy, and Paste Special-Values of the worksheet
Stage 3: Delete Columns A-R [so that the format is as worksheet 1(2)]
Stage 4: Save this worksheets as a separate workbook somewhere e.g H:\New Folder (2)\Excel Forum
Then move onto next worksheet i.e 2 and repeat.
The loop process needs to be from sheet 1-435.
Bookmarks