resorting tables



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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question