Need macro to split excel sheet into multiple excel workbook
Hi 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 s1@gmail.com
2 Tom s2@gmail.com
3 Maddy s3@gmail.com
I want to split this excel sheet data into 3 excel workbook like below
s1@gmail.com.xlsx which contain 1st row data only with header No.,Name and Email
s2@gmail.com.xlsx which contain 2nd row data only with header No.,Name and Email
s3@gmail.com.xlsx 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.