I am trying to set up a document control system that uses a sheet as a master
index of all documents created in our business. Then have additional sheets
in the same workbook that list a certain category of documents such as
"Wiring Diagrams" or Specifications.
We are using Excel 2003 SP2.
Is there a way to code the supplementary sheets to automatically search the
Master Index sheet as new data is entered for a category and if found to copy
the new row of data into the next available row on the destination sheet?