Automatic seek and copy data from one sheet to another
 

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?

Automatic seek and copy data from one sheet to another
 

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?

Automatic seek and copy data from one sheet to another
 

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?