Create Separate Excel Workbook based on Main File

[maheshrk81]

Hi All,

I have a Master Excel file which is refreshed with all the data. In the Master file, in 2 sheets (Data1 and Data2), i have data of all the customer Amount. In Column B, I have customer names. Now i need to create a macro to Create Separate Excel Workbook for each customer based on Main File and save in a file location automatically.

Can someone please help asap.

Thanks,
Mahi