Hello,
I have a workbook name Budget Template FY 15 and I have a list of customer in sheets("Customer"). Is there a macro that can help me save this workbook with different name based on the customer tab in the same folder.
For example, in the customer sheet A2 = CUST-1028. the Vba will go to the BIT tab and change cell B4 to CUST-1028 then it will close the workbook and save it in folder C with the name of "Budget Template FY 15 - CUST-1028. THEN it will go to the next cell A3 and repeat the process with next customer.
I have to do this manually with 200 customers. Please help.
Thanks
Bookmarks