i have two workbook... i want to merge them in one workbook but in different sheet.
i don't want to merge the sheets.
Solved! Go to Solution.
If you can provide sample templates that will be a great help to understand your needs
WORKBOOK1 - SHEET1
WORKBOOK2-SHEET2
MERGE WORKBOOK 1 AND WORK BOOK 2 INTO WORKBOOK 3 WITH 2 SHEETS .
WORKBOOK3 WILL CONTAIN TWO SHEETS
SHEET 1 & SHEET 2 SEPERATELY
There are variety of solutions already posted and hope one of them should help:
Thanks a Lot. I never thought this would be this simple.
Thanks !!