Jagdev
01-14-2015, 02:54 AM
Hi Experts
I am stuck with the attached macro and need your help to add few more features into it. Currently it is picking list of workbooks available in a default location and copy them one by one in each tab of the macro. Please help me to fulfill the following criteria.
The Macro should create a copy named "Master" and perfrom the copy each sheets in tab one after the other instead of performing the same action in the macro sheet.
In the current macro when I run it second time it creates addional tabs, is it possible for the macro to delete the old tabs and then create the new one.
Regards,
JD
I am stuck with the attached macro and need your help to add few more features into it. Currently it is picking list of workbooks available in a default location and copy them one by one in each tab of the macro. Please help me to fulfill the following criteria.
The Macro should create a copy named "Master" and perfrom the copy each sheets in tab one after the other instead of performing the same action in the macro sheet.
In the current macro when I run it second time it creates addional tabs, is it possible for the macro to delete the old tabs and then create the new one.
Regards,
JD