I'm trying to avoid using a macro ...
I have a table with 7 columns with a header ...
- Column A contains a header ("Order") (row 1) and the numbers 1 to 60 (rows 2 to 61)
- Column G contains a header ("Surname") (row 1) and surnames (but only in rows 1 to n, with rows n+1 to 61 blank)
I want to sort the table on Column G (A to Z) using the Autofilter, but with the blank rows at the bottom (not at the top) ...
Is this possible NOT using a macro?
Many thanks ...
I have a table with 7 columns with a header ...
- Column A contains a header ("Order") (row 1) and the numbers 1 to 60 (rows 2 to 61)
- Column G contains a header ("Surname") (row 1) and surnames (but only in rows 1 to n, with rows n+1 to 61 blank)
I want to sort the table on Column G (A to Z) using the Autofilter, but with the blank rows at the bottom (not at the top) ...
Is this possible NOT using a macro?
Many thanks ...