I have a workbook which I want each worksheet within it to update from a
master workbook that is closed. The worksheets in the master are updated
often with new info and columns are added and / or deleted with each update.
What I need is for the destination worksheets, when opened, to update to be
exact duplicates in every way from the worksheets in the master/source
workbooks.

Thanks for your help.

Why not just open the Master/Source workbook and then immediately use
File | Save As and save the file with a different name?

Hope this helps.

Pete

On May 16, 7:10*pm, LLK wrote:
I have a workbook which I want each worksheet within it to update from a
master workbook that is closed. The worksheets in the master are updated
often with new info and columns are added and / or deleted with each update.
What I need is for the destination worksheets, when opened, to update to be
exact duplicates in every way from the worksheets in the master/source
workbooks.

Thanks for your help.

Take a look at this:
http://www.rondebruin.nl/tips.htm

and specifically this:
http://www.rondebruin.nl/ado.htm


Regards,
Ryan---

--
RyGuy


"LLK" wrote:

I have a workbook which I want each worksheet within it to update from a
master workbook that is closed. The worksheets in the master are updated
often with new info and columns are added and / or deleted with each update.
What I need is for the destination worksheets, when opened, to update to be
exact duplicates in every way from the worksheets in the master/source
workbooks.

Thanks for your help.