In Col A I have a list of places, Col B a reference and Col C a number. There can be up to 30 rows of data.
I would like a VBA code to do the following...
Sort by Col C - smallest number first
Then delete any data in Cols A & B where Col C is blank
Bear in mind that there can be up to 30 rows of data.
I do not want to delete the entire rows as I have other data in Cols F:K that I want to keep.
Any help would be appreciated
Many thanks
I would like a VBA code to do the following...
Sort by Col C - smallest number first
Then delete any data in Cols A & B where Col C is blank
Bear in mind that there can be up to 30 rows of data.
I do not want to delete the entire rows as I have other data in Cols F:K that I want to keep.
Any help would be appreciated
Many thanks