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
 

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

Similar Threads

How to update data entry to a linked worksheet and then return thenew value back to a master workshe 0
Sub projects added as read only in Master file which are saved on sharepoint 1
Syncing between source worksheet and dependent worksheets 0
Excel linking from one master worksheet to many worksheets and ableto return a value back. 0
Dumb question alert! What program to use? 0
index-match function across different worksheets 0
Linking data from one worksheet to another... 2
How to update data from linked worksheet back to a master worksheet? 0

Top