Merging workbooks and worksheets :: MrExcel Message Board


 FAQFAQ
   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   FavoritesFavorites   StatisticsStatistics 
 RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 
Online StoreOnline Store

MrExcel Message Board Forum Index -> Excel Questions

Merging workbooks and worksheets
Post new topic   Reply to topic
Last Thread | Next Thread  >   Printable version
  Author    Thread

Dimwhit
Board Regular


Joined: 18 Jul 2002
Posts: 14

Flag: Blank

Status: Offline

 Reply with quote  

Merging workbooks and worksheets

OK, I've looked all over. I think this can be done, but I'm not sure how to do it. Here's what I'm attempting:

I have 10 separate xls files. Each contains a list of information, broken out over several columns (date, location, event, trainer, etc.). Each file contains the same type of info.

I want to do two things. First, I'd like to set up a master file with 10 tabs. I would like each tab to exactly mirror the contents of the external files. When one of those files has an event added, modified, or deleted, I would like the corresponding tab to update.

Then I would like to create an additional tab in this master file that will merge the other 10 tabs of information into one long table.

Is this possible? I know how to create a simple link from one workbook, but this isn't quite the same thing.

Thanks.

Post Fri Sep 19, 2003 5:05 pm 
 View user's profile Send private message

earlyd
Board Master


Joined: 11 Dec 2002
Posts: 955

Flag: Usa

Status: Offline

 Reply with quote  

Re: Merging workbooks and worksheets

It is certainly possible, but there is a lot of work and it requires a fairly long explanation with a lot more questions. You would need to add VBA to all of your workbooks to do what you are asking. Are you sure you wouldn't rather just periodically or on demand "get" the data from the other workbooks? Then you only need to add VBA to your "portfolio" workbook.

Post Fri Sep 19, 2003 5:16 pm 
 View user's profile Send private message

Dimwhit
Board Regular


Joined: 18 Jul 2002
Posts: 14

Flag: Blank

Status: Offline

 Reply with quote  

Re: Merging workbooks and worksheets

Doing it on demand would certainly be doable. Especially if it's significantly easier that way. And it would work to just draw the the external files directly to a master sheet where they all get merged.

Post Fri Sep 19, 2003 5:19 pm 
 View user's profile Send private message

earlyd
Board Master


Joined: 11 Dec 2002
Posts: 955

Flag: Usa

Status: Offline

 Reply with quote  

Re: Merging workbooks and worksheets

Assuming you are going to list the files that you need to read create a sheet to list the files and loop through them, each time opening the file, copying what you want, and then closing the file.

Post Fri Sep 19, 2003 5:57 pm 
 View user's profile Send private message
  Display posts from previous:      

MrExcel Message Board Forum Index -> Excel Questions


Forum Jump:
Jump to:  

Post new topic   Reply to topic
Page 1 of 1



Add To Favorites

 


Forum Rules:
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Powered by phpBB: 2.0.4 © 2001 phpBB Group

Need help posting your first question? Read how to post

Need extra help ? Couldn't get the answer you needed ? Get a free quote from our Consulting Team

Download Colo's HTML Maker utility for displaying your Excel Worksheet on the board.

Download VB HTML Maker to post your code on the board


Check out our new index to 485 Excel Articles.


Return to MrExcel Consulting

All contents Copyright 1998-2004 by MrExcel.com
If you believe information posted here is from your copyrighted source, notify us per the Terms of Use
Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.