resorting tables

N

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

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

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel Highlighting duplicates 0
VBA - retrieve data on last create named range from previous inserted named range 0
Absolute References and worksheets 0
Access 2003 1
Excel VBA 1
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
VBA Excel - Select a value from one cell in Excel to update a SQL table 1

Top