Sort ascending, make changes, restore previous order

B

BVHis

I've got an AutoFilter in a spreadsheet. I want to sort ascending, mak
some changes to some cells, then restore the previous order. Can thi
be done easily or will this require some programming??

Thanks in advane!

Matt
 
D

Dave Peterson

I'd use a helper column.

Put =row() and drag down.
Convert it to values (edit|copy, edit|paste special|values)

Do all you want and then sort by this helper column when you want the original
range.

(Then delete that helper column???)
 
Top