maheshrk81
Board Regular
- Joined
- Jan 5, 2010
- Messages
- 153
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
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