Sorting of worksheet, half of columns are formulas referring to 1st worksheet...

  • Thread starter Thread starter abulawski
  • Start date Start date
A

abulawski

I want to sort my worksheet alphabetically by last name. Half of my
worksheet columns contain contact information that are formulas
referring to another worksheet in the file. The other half is regular
values of dates in different columns. (We use the file to track
correspondence). I added 100 more rows to the worksheet.(about 300
total). Now I need to sort, but everything I try results in the rows
getting switched around. Ex: Dr. Smith's dates aren't correct.
They're on Dr. Smyth's row. Dr. Smith has Dr. Snyder's dates. Any
ideas? Thanks.

Angela
 
I want to sort my worksheet alphabetically by last name. Half of my
worksheet columns contain contact information that are formulas
referring to another worksheet in the file. The other half is regular
values of dates in different columns. (We use the file to track
correspondence). I added 100 more rows to the worksheet.(about 300
total). Now I need to sort, but everything I try results in the rows
getting switched around. Ex: Dr. Smith's dates aren't correct.
They're on Dr. Smyth's row. Dr. Smith has Dr. Snyder's dates. Any
ideas? Thanks.
Click to expand...

It sounds like you might be sorting the sheet that the links come from
instead of the sheet that contains the links.

Jordon
 
Back
Top