Need macro to split excel sheet into multiple excel workbookHi Team,
I want macro to split excel sheet data into multiple workbook with email id as excel workbook name.
i have below data in one excel sheet
No. Name Email
1 Rahul firstname.lastname@example.org
2 Tom email@example.com
3 Maddy firstname.lastname@example.org
I want to split this excel sheet data into 3 excel workbook like below
email@example.com which contain 1st row data only with header No.,Name and Email
firstname.lastname@example.org which contain 2nd row data only with header No.,Name and Email
email@example.com which contain 3rd row data only with header No.,Name and Email
This excel sheet data may vary sometimes it is 500 or sometime it is 100. According to no of rows it should create excel workbook. like if 100 rows then 100 excel files not sheets.