Data autofilling from multiple workbooks into one "master" workbook

F

Faith

I keep client records, demographics, invoices, etc, etc.
and use one workbook per client using the different
worksheets like tabs in a binder.

I also want to be able to see a total listing of some of
these items, a master name, address list for example.
What I've been doing is cutting and pasting from the
seperate workbooks to one "master" workbook. It's very
time consuming.

How can I tell each individual workbook to copy certain
fields to the master

and

How can I have it so that the information goes into the
next available empty cell?


Thank you.
Faith
 

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

Top