actually guys there is another problem which i was hoping you could help with.... post filter a specific cell is selected.

ActiveSheet.Range("$A$1:$I$" & LastRow).AutoFilter Field:=5, Criteria1:="JZB"
Range("E5").select

representing the firstrow of the selected criteria.

is there a way i can replace this cell with some sort of variable as the data varies each time?

the only idea i have is to loop through the data first to identify the row the filter will point to but was hoping there was a more efficient way of doing it.

thanks for the help

JZB