Updating a master workbook with 80 workbooks
 

Hi there

I have a "master" workbook which I would like to automatically update with
the data that is constantly changing in 80 workbooks.

The data in the workbooks may have rows of data that is added, deleted or
edited.

The 80 workbooks also contain a couple of columns which have "drop-down"
boxes (validation that is limited to a list) - this data will have to be
shown in the Master workbook. Once it is in the Master I may want to change
the validation data - is this possible?

My main question is: what is the cleanest way of having the master update
with any new data in the 80 workbooks? I thought about using links but maybe
there is a macro which I could run from the master which might be cleaner?

Any help much appreciated, thanks

Lara

Updating a master workbook with 80 workbooks
 

Hi

One way

If you need the data run a macro or use the Add-in
See
http://www.rondebruin.nl/copy3.htm



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"La La Lara" <La La wrote in message ...
Hi there

I have a "master" workbook which I would like to automatically update with
the data that is constantly changing in 80 workbooks.

The data in the workbooks may have rows of data that is added, deleted or
edited.

The 80 workbooks also contain a couple of columns which have "drop-down"
boxes (validation that is limited to a list) - this data will have to be
shown in the Master workbook. Once it is in the Master I may want to change
the validation data - is this possible?

My main question is: what is the cleanest way of having the master update
with any new data in the 80 workbooks? I thought about using links but maybe
there is a macro which I could run from the master which might be cleaner?

Any help much appreciated, thanks

Lara