"bj" wrote:

Could you give an example of what you want it to do and what it is doing. If
the cell reference were A3 it should still be A3 after the sort of sheet 1,
do you want it to follow the sort?

"JohnR" wrote:

When using "=(SHEET1!cell_reference)" in sheet2, if I sort sheet1, sheet2
does not have the correct data.
bj, Yes , I would like it to follow the sort.