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