Macros to split large data to separate workbooks and worksheets

Macros to split large data to separate workbooks and worksheets

May 23 '23 Comments: 6 Answers: 1

-1

I'm looking to combine 2 macros to split large data in Excel to many workbooks and each workbook should be split to separate worksheets. Column A should determine the split in to workbooks and Column B should split to separate worksheets within each new workbook. Here are the 2 macros:

…

Open Full Question