Quote:
Originally Posted by 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.
|
I understand that you want to sort the data in sheet1 (parent) and should not reflect any change on the other sheet referring sheet1 (parent)
Workaround is here
make a copy of sheet1 and sort there.
steps 1: right click on the sheet1
step 2: choose move or copy
all the best