linking worksheets to a closed workbook

L

LLK

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.
 
P

Pete_UK

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
 
Top