Population of a master workbook from several other workbooks

**DragonFly31** · 08-21-2007, 05:27 AM

I have been trying to build a 'master' workbook that would be built upon the addition of other workbooks.

My employees, as part of their responsabilities, make NCR's (Non Commissioning Reports), for various parts of engines which are defectuous or have failed. They are fairly common and new ones are constantly added.

It is difficult to keep track of them, as they are stored in different folders with different names and part numbers. We try to keep an index, but manually doing so is still difficult and errors are still made (including duplicates from time to time), as these are also shared on a vast computing network.

Hence, this 'master' or 'index' workbook should automatically realize when a new workbook (NCR) is created, adding the new NCR to itself.

I have attached an example in zip as to what an NCR is. Only crucial information would have to be referenced to the 'master' workbook (ie. Engine S/N, Part N°, and a few others.)

Is this possible?

Thank you in advance for your help.

**mrice** · 08-21-2007, 03:16 PM

One strategy that you might chose to use is to have a Workbook_BeforeSave macro on your template sheet which takes the important data items and puts them into a simple .csv file in a defined folder. Your master sheet could then contain a macro linked to the workbook_open event and which examines this folder and adds any new entries to its list.

As one of the data entries, you could have a path and filename for the source data and create a hyperlink which could take you back to the source workbook with one click.