Linking Excel Worksheets w/Sorts

[newtoaccess3]

Does anyone know whether you can link one worksheet (in one file) to another worksheet (in another file)which contains the exact same headers/information, but has been sorted. If so, How can you get the data to update automatically in the sorted worksheet? When answering, please start from scratch because I have not been able to link them thus far from the information I have obtained from the help button and Microsoft's Bible to Excel 2000. Thanks a Million! Helpless in PA!

 

[Dreamboat]

This is not a nice situation.

Given your nickname, why aren't you using Access? It would by far be the better choice--sounds like!

NotVeryHelpfulInPA
~Dreamboat

http://www.TheWordExpert.com

 

[SkipVought]

Hi,

There is really no trick to doing this in Excel.

On the sheet that you want to link, you need a reference in each cell that you are linking to the other workbook.

1. Have both workbooks open to the sheet that you want to work on
2. In the TARGET workbook, select the cell that you want to link
3. Type the EQUAL SIGN (=) and then select the SOURCE workbook, selecting the cell that has the data you want to link and hit enter. The data from the SOURCE workbook should be displayed in the cell that you just entered the reference in.
4. Now in the TARGET workbook, copy that cell to each cell that you want to have data in from the SOURCE workbook.

Each time you open the TARGET workbook, it will ask you if you want to update the links to the SOURCE workbook.

VOLA! Skip,
metzgsk@voughtaircraft.com

 

[LSTAN]

Hi

Yes, it can done. Just type this into the cell in Book2.xls (or the workbook you want to link);

='C:\My Documents\[Book1.xls]Sheet1'!A1

This function can be cut and paste just as normal Excel function.

No matter which worksheet you sort the data will be automatically updated.

As an illustration, let say you sort Book1.xls data in an ascending order and because Book2.xls data is link to it, the data in Book2.xls will be also in an ascending order.

Let say again, you decided to sort the data in Book2.xls in a descending order, bear in mind that Book1.xls data will not follow the sorting of Book2.xls. If there ia any changes of data in Book1.xls, Book2.xls will automatically update regardless which sorting order both are.

Hope this is clear.

rgrds
LSTAN

 

[newtoaccess3]

THANKS FOR ALL OF THE TIPS!!! I LOVE THIS SITE!!!! -NOT SO HELPLESS ANYMORE IN PA-