Filter Data to Top Row of Column - Eliminate Blanks

Hi folks,

I am filtering data in column A - example



+------------+----------+------+
| Vegetables | Apple | Plum |
+------------+----------+------+
| Plum 1 | | |
+------------+----------+------+
| Plum 2 | | |
+------------+----------+------+
| Apple 1 | Apple 1 | |
+------------+----------+------+
| Apple 2 | Apple 2 | |
+------------+----------+------+



I did this manually using the filter for Apple

ActiveSheet.Range("$A$1:$C$5").AutoFilter Field:=1, Criteria1:="=*Apple*", _
Operator:=xlAnd

However can you see the rows above apple are empty

How do i put these to the top of the row, I will then repeat for Plum,

What I am trying to achieve is the results for each search to start at the top of the column
rather than just be placed on the offset, i hope i am making sense

thank you

sl

I did have to use helper columns, but you could move them and then change the reference to the new location or simply hide the helper columns. I hope this helps.

Hello,

thanks for your help, some new formulas for me -

I'm really bad with formulas but I'm sure I'll be able to do sort it

cheers

sl