Splitting Workbook With Color
There is an Excel file that teaches how to perform the Splitting Workbook With Color operation.
Excel Powered Splitting Workbook with Color
This workbook demonstrates splitting workbook with color using VBA macros on a 6-row data layout.
Hope it is useful.