Auto Filter Sorting Issue

R

Ryan@Wpl

I have a large spread sheet and frequently use the auto filter capabilities.
My rows are getting out of sequence (the data is not staying in the correct
row). I've marked cells and then tested by sorting different columns
ascending, desending, etc. and I've done this on multiple columns. I can not
get the data to return to the original format even when I turn the filters
off. I have in excess of 100 hours invested in this data. Needless to say
it's a very important document! Any help will be greatly appreciated.
 
P

Pete_UK

If you want to get back to original order of the rows, then you can
put a simple sequence 1, 2, 3, 4 etc down a column before you start
changing anything in your sheet. Then you will always be able to sort
back to this sequence. Remember to include this column in the sort
range whenever you sort.

Hope this helps.

Pete
 

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

Top