Split Excel Spreadsheet Data Into New Workbooks based on page breaks

I need VBA code to split Excel spreadsheet Pivot Code data into new workbooks based on page breaks. Each page may have multiple sets of records with varying number of rows and consistent columns. Would want to capture all data from MasterSheet as laid out in MasterSheet.

Example:

Col1 Col2 Col3 Col4 Col5

Supervisor1

Emp1

Info1 X X X

Info2 X X

Info3 X X

Emp2

DDD1 X X

EEE1 X X

Emp3

GGGG X X

-----Page Break

Supervisor 2

Emp2

HHHH X X X

-----Page Break

Supervisor1 and all row/column information would end up in Workbook1 with Tab titled Supervisor1
Supervisor2 and all row/column information would end up in Workbook2 with Tab titled Supervisor2


Thanks in advance for any help provided.

Steve

Hi Steve,

Please try

Please Login or Register  to view this content.

Good for you! Please remember to click the "*" if you are happy with my contribution