How do I link 2 worksheets in different files?
 

I am using a master spreadsheet and want to create an "abridged" copy (in
another file) which would only have a select portion of info from the master
sheet. When I update the master sheet I would like it to automatically
update the abridged version. How do I do this? (Also, I will be using text
info only)

This is what I did when I wanted a summary sheet from multiple sheets and
workbooks. first I created the workbook for the summary sheets (one for every
month). I held control and clicked 12 of the tabs, this allowed me to create
and modify the layout for all 12 sheets at once. I then created the executive
summary sheet that had the information I needed from the 12.
This is how I made the links to the other pages and workbooks.
I had the workbooks open and on the page and in the cell where i wanted the
information I hit = then I went to the workbook/page/then clicked on the cell
that had the information. all you need to do at that point is hit enter and
your link is created.
If the information is in the same col. or row you can drag your cell to
repeat the formula for the other cells (the $ is needed in front of the info
that stays the same) If not then repeat the process.
If your formula is =a1 and the links are all in the A column then it would
need to look like this =$a1. So the only variable is the cell number(the
linked formula will have the workbook and sheet name in front of the cell and
row name). I'm self taught so I bet there is an easier way, I hope I helped
and didn't add the the confusion.




"mocha joe" wrote:

I am using a master spreadsheet and want to create an "abridged" copy (in
another file) which would only have a select portion of info from the master
sheet. When I update the master sheet I would like it to automatically
update the abridged version. How do I do this? (Also, I will be using text
info only)

In the new workbook enter the following formula for the appropriate cells:
=[YourFileName.xls]YourSheetName!A1
(substitute A1 with your cell ref)
If you have both workbooks open you can use the point method to enter the
formula.
This is a link to the original data and will update as the original does.
Good luck!

"mocha joe" wrote:

I am using a master spreadsheet and want to create an "abridged" copy (in
another file) which would only have a select portion of info from the master
sheet. When I update the master sheet I would like it to automatically
update the abridged version. How do I do this? (Also, I will be using text
info only)