I am trying to delete all rows that don't have any data in column f
Row 1 is column headings
Column F is a date field and is not sorted
I was thinking of doing the following (but don't know the code), but maybe there is an easier way.
I was going to sort from A to F from 2 to last row
then find the first empty row after the sort
then delete all the rows below the last data row
Thanks for any help or direction
Josh
Bookmarks