PDA

View Full Version : Merging different workbook into one workbook in different tabs.



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

Jagdev
01-14-2015, 03:24 AM
Hi Experts

I find the fantastic link here - http://www.vbaexpress.com/kb/getarticle.php?kb_id=829, but it still do not fulfill the above 2 requirements.

Regards,
JD

Jagdev
01-15-2015, 02:42 AM
Hi Experts

Please let me know your view on the above thread.

Regards,
JD