From your description it's obvious, you are sorting only a part of table -
maybe a single column.

Before performing sorting, be sure there is no gaps (empty rows or columns)
in your table - then when selecting a single cell from table, sort operation
sorts whole table automatically. When you leave any gap into table, the only
way to sort properly is to select the whole table manually.

Partial sorting will corrupt your table irrecoverably - your data become
meaningless gibberish.

Arvi Laanemets


"am" wrote in message
...
Hi,
When I perform a data sort on a worksheet two of my columns don’t sort
with
the rest of the data.
For example a sort by first name changed to a sort by surname means these
two columns of cells still reference the original cell
='Employee db - Master'!H2 should change to ='Employee db - Master'!H43
after the sort but it doesn’t, it stays the same and references the wrong
data.
I’ve tried $H$2 that doesn’t work

How can I keep the cell pointing to the correct data in through a sort?

Many thanks


However, if I cut and paste cell B2 in sheet2, then sheet1 A1 follows
sheet2B2 anywhere I put it.

How can I keep cell A1 pointing to the data in B2 through a sort?