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.
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.