Automatic seek and copy data from one sheet to another

G

Guest

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?
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Move or Copy Stopped Working? 0
Copy specific data form sheets into master sheet 6
Splitting data from one spreadsheet into multiple spreadsheets 2
Excel, assign cells in multiple worksheets from one sheet 1
Excel-Adding rows to master sheet that will be inserted on following worksheets 1
Transferring data from multiple sheets in workbook to one sheet 5
How do I automatically copy data from one sheet to another? 1
using the =page! feature to transpose a row to column 0

Top