Auto Filter Sorting Issue

  • Thread starter Thread starter Ryan@Wpl
  • Start date Start date
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.
 
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
 
Back
Top