Creating Linked Documents With Master Document Updating Second.

Hi,

Where are these two documents held? On the same PC or are they available across a network by you and the secretary?

It seems to me that the ideal solution is to have a single document which you both access.

Failing that you'll need a macro to extract and pass details to you so that you can import bookings to your workbook. The simplest arrangement would be a macro in the secretary's workbook which automatically extracted and saves a simple file of dates and times every time he closed his workbook, and immediately after saving the macro whould generate an automatic email to you attaching the file in the process. Your system would then have a macro to import this file and update your list.

We'd need to see specific layouts to advise further, but that's the general approach I'd adopt. As I say it would be far simpler with just one workbook.

Regards