Need help to modify the code so that it splits the workbook into individual worksheet

I have a workbook with the following worksheets “PreviousFN”, “CurrentFN”, “OmittedMbrs”, “NewMbrs”, “CommonEID” , “PayPeriod”, “Section” and “ImportHere”

I want to split this workbook create workbooks but I don’t want to create all the workbooks. I want to create “PreviousFN”, “CurrentFN”, “OmittedMbrs”, “NewMbrs” and “CommonEID” only and only if they have data in each worksheet. They all have headings.

The present code is creating workbooks of all the sheets. I don’t want to create “PayPeriod”, “Section” and “ImportHere”. "CommonEID" does not have the data.

Please, I need help to modify the code to do so.

Please Login or Register  to view this content.

Thank you regards.

Raghu

Hi

to clarify

• do you want to create a new workbook for each of the sheets you name, each workbook containing one sheet only; or
• do you want one workbook with each of the sheets you name, but only if they contain data other than headings

and

• are your headings in a single row at the top of the sheet (so any sheet with more than one row in its used range contains data?)