Excel Spreadsheet

[Ninfa12]

I have a spreadsheet B that referes to spreadsheet A. If I
sort spreadsheet A then the references for B don't match.
What do I need to add to the formula that will allow it to
follow it no matter how spreadsheet A is sorted?
Thanks

 

[Steve Smallman]

First thoughts are that the formulae in sheet B are entered as absolute
references i.e. they have $ signs preceding the row and column this would
mean that the formula would look like "SheetA!$A$2". this would cause your
problem as absolute references do not change when the data is sorted, or
when rows or columns are inserted.

If this is the case remove the $ signs (click in the formula bar in the cell
reference area and press F4 to cycle through the options)

Steve