Skip to Content
0
Former Member
Dec 01, 2008 at 06:01 AM

Merge (or Consolidate) two workbooks into one

64 Views

Hi,

I have a workbook1 which has query 1, 2, 3 in it. There is lots of vbcode and other stuff which I donu2019t want to change. Now I want to add query 4, 5, 6 in to the same workbook1 i.e. by creating few more tabs or worksheets inside it along with Query1, 2, 3. So that I still want the same workbook with all the format, coding, links etc. for another 3 queries and save this workbook as workbook2. In short want to get the replica of earlier workbook with several more queries embedded. How to do that? Pls advice.

Thanks & regards,

Shree.