LinkBack URL
About LinkBacks
Dear Friends,
Please help me to solve this query.
I have a 40 workbooks with single worksheet in it, i just want to merge all those 40 workbook with single sheet in it with master workbook containing all those sheet.
thanx in advance
Dear Friends,
Please help me to solve this query.
I have a 40 workbooks with single worksheet in it, i just want to merge all those 40 workbook with single sheet in it with master workbook containing all those sheet.
thanx in advance
Hi
Open up a master workbook. On each of the other workbooks, right click on the sheet tab and select move/copy worksheet. Select the master workbook from the drop down list, tick Create a copy, or not at your discretion. You will end up with a master workbook with all the sheets that you want.
Chris
Do you want the data to be copied to one single sheet or do you want it to be copied as separate sheets in the master workbook?
Will the master workbook be blank before running the macro?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Hi Amaan,
Try this..
Please Login or Register to view this content.
Last edited by arlu1201; 10-25-2013 at 06:33 AM. Reason: Corrected code tags.
Dear anand,
i must really apprecite your response and hardwork to design the code.
this really helps me alot.
thankyou brother.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks