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?

Ice

Browse through Ron de Bruin's Copy/paste/merge examples.

http://www.rondebruin.nl/tips.htm

One of those will have code for you.


Gord Dibben MS Excel MVP

On Fri, 27 Apr 2007 13:50:02 -0700, Ice Man
wrote:

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?

Thanks for the lead on this Gord. I didn't respond sooner because I was not
notified of your post. I thought I clicked the notify me button but I guess
not. After a week or so I forgot which forum I placed the question and just
found it today.
I'll check out Ron's stuff. Thanks again.

"Gord Dibben" wrote:

Ice

Browse through Ron de Bruin's Copy/paste/merge examples.

http://www.rondebruin.nl/tips.htm

One of those will have code for you.


Gord Dibben MS Excel MVP

On Fri, 27 Apr 2007 13:50:02 -0700, Ice Man
wrote:

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?