Hi all,
I have several workbooks with exactly the same structure (ie. columns and headers). These are stored on a particular folder. I would like to have a master workbook with exactly the same structure, but the data is populated depending on which workbook i select to view (possibly a dropdown list). This way, I dont have to go into the individual workbooks to check the data, but rather check it all on one workbook.How would I go about doing this?
Thanks in advance
More detail needed:
When a workbook is selected is data in the Master added to, or replaced?
In Master workbook, is there a worksheet per workbook?
Post a sample files: MASTER and a sample workbook illustrating your expected outcomes.
Couldn't you just have a dropdown that lists the workbooks and when you select one and click a button that workbook is opened?
If posting code please use code tags, see here.
The data is replaced. The purpose of the master is to view the data and to check if data has been inputted into the workbook. Each workbook has three worksheets. All identical in structure. The master will have the same with the addition of some select function to select the relevant workbook. I will post sample files later as they are one a home computer.Originally Posted by JohnTopley
Thanks
Last edited by mufakkir; 06-21-2016 at 08:11 AM.
See reply from Norie: seems a very sensible approach to me.
To do what you specifically ask you would need to open the workbook anyway.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks