is it possible to sort rows while the autofilter feature is applied.
meaning i apply the autofilter feature and filter some rows (say out of 100 rows 30 are visible after column C has been filtered for a value)
can i then apply a sort on the visible rows only between the range say column A to column K with only the visible filtered rows selected (header and other area not selected, assuming i do not care whether the invisible / hidden rows get sorted or not, though ideally i would not want to change anything in the hidden rows)
is there a macro workaround available ? i do not want to write a bubble sort (i am not much good at any other good sorting algo..) on the visible rows, as there will be cases where i may have about 6000 visible rows (on a total data of about 30000)
i am using ooo 3.0 (65K rows max, i think .. please correct me if i am wrong there..)