Your attached workbook gives very little for anyone to work with. There are no column headings, no indication of how the data might be related to what's in the other workbooks, etc.
In any event, you'd do far better setting up an Access database for this kind of thing.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|