We have a large worksheet used by many users that may have various filters on
various columns at any given time. Column A contains data 0 thru 8. I need
code to add to a macro that will sort the worksheet by the VISIBLE data in
Col A as follows: 0 must always be at the top, then the first visible row
with a 1 would be next, then the first visible row with a 2, then the next
row a 1, then a 2, etc...the remaining rows with 3-8 may just show in
ascending order all 3's, all 4's etc...so that column A will look like
0,0,0,1,2,1,2,1,2,1,2,3,3,3,3,4,4,4,....etc
This would be a great help.
--
Holly