resorting tables

[NJEd]

I am building a database with cell references from one worksheet to another.
How can I resort the original table without corrupting the data because the
cell position has changed.
Thanks for any suggestions.

 

[Gord Dibben]

Not sure what you're asking for.

Do you want to sort Sheet1 and have Sheet2 remain static?

As long as you have linking formulas in Sheet2, data will move when Sheet1
is sorted.


Gord Dibben MS Excel MVP