Only things I can think of is to...
1) use vlookups
or
2) use the Indirect function
For example, put 'Sheet1!A3 (with the single-quotation mark in front) in
cell B11 and in cell C11 put
=INDIRECT(B11)
Since 'Sheet1!A3 is text and not a reference, it won't change when you sort.

HTH,
--
Gary Brown

If this post was helpful, please click the ''''Yes'''' button next to
''''Was this Post Helpfull to you?".


"Barry" wrote:

I have two worksheets in a workbook. One of the columns in worksheet 2 is
referenced to a column in Worksheet 1 (i.e. cells containing peoples names).

When I sort Worksheet 1 on the cells containing names it also sorts
worksheet 2.

Is there a method to NOT sort the worksheet 2 when I sort Worksheet 1?