sort worksheet without affecting workbook

B

Barry

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?
 
G

Gary L Brown

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,
 
B

Barry

Gary

I don't think you understood my question. Column A in sheet1 contains
persons names. In sheet2 Column A references sheet 2 with =sheet1!a1 etc in
each cell in Column A so all the persons names shows in sheet2. I now want to
sort sheet1 on perhaps column A other other columns for example, but sheet2
also sorts on column A this is understandable since sheet2 is referencing the
cells in sheet1. I am asking if there is a method to NOT sort sheet2 on
column A.
 
G

Gary L Brown

Barry,
You're right. I misunderstood. You want the formulas in sheet2 to follow
the sorted values in sheet1 whereever they end up on sheet1.
Unfortunately, without making sheet 2 values and destroying the formulas,
you can't do that.

Sincerely,
 
Top