Sort ascending, make changes, restore previous order

  • Thread starter Thread starter BVHis
  • Start date Start date
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
 
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???)
 
You must log in or register to reply here.

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

Ascending order sort.. 1
Macro Sort Errors 2
Excel 2007 Sort-How to Retain Sort Order 3
Sorting a column in a spreadsheet 2
Sorting Ascending but put empty fields at the end... 3
How do i sort a range and place the results in another range without using Macros? 1
VB macro ascending & decending Alpha sorting on protected sheet 4
Sort Ascending/Descending 2

Back
Top