Hi Ashan
If your 'Index' values are stored as a master list in the summary workbook, you could use a LOOKUP formula to retrieve to values from each of the other workbooks.
If your 'Index' values are not stored as a master list in the summary workbook, you would need a macro-based solution that would open each source workbook, check its index entries against those that might (not) already be in the summary workbook and if, not found in the summary workbook, add the index entry. You can then use the formula approach mentioned above, or have your macro copy the value to the relevant column for the index row.
As you can see from the above, one possible solution is fairly simple and can use just formulae; the other is much more complex and requires a macro for at least part of the process.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|