Link Workbooks - Auto Update

K

Katlegal

I have multiple workbooks (source workbook with multiple sheets) in which
dates, addresses and text are input. (I am essentially using Excel as a
database.) I want to link each of these workbooks to one master workbook
that updates the "status" of an activity when a new "entry" is logged into
one of the source workbooks. i.e. If I have new activity and open my source
workbook to "Diary," insert a new row, and in Column A enter the date, and
Column D enter the results of that activity, when I open the master workbook,
I want the corresponding cells in the master workbook to reflect the entries
I typed in the new row. Any assistance is greatly appreciated!
 

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