Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
referencing cells in different workbooks
HELP! I have two different workbooks, and I am referencing cells in one
workbook (call it test1) to another workbook (call it test2). I want the cell in workbook test2 that contains the referenced cell from workbook test1 to keep the same cell reference after I sort the workbook test1. For instance, if the formula in workbook test2 contains ='[test1.xls]Sheet2'!$G$33, and after sorting workbook test1 that same cell now is in,say G56, I want the reference in workbook test2 to follow to the new cell adress in workbook test1. What can I do to acomplish this? -- jandrews |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Referencing Other Workbooks | Excel Discussion (Misc queries) | |||
Referencing other workbooks | Excel Worksheet Functions | |||
Referencing cells in closed workbooks | Excel Discussion (Misc queries) | |||
Referencing Cells in a different workbooks | Excel Discussion (Misc queries) | |||
Referencing workbooks | New Users to Excel |