Vba filter

[dimitrisko]

Hello guys. I came to a dead end and need help. I have an archive with football games. I created a simple vba macro for advanced filtering to transfer data to another sheet. Lets say i have in my archive for today Barcelona-R. Madrid with odds 1,95 - 3,20-3,50 for 1x2 and filter those and if there is a match previously with exact same criteria its ok. What i want to do now is do the same advanced filtering but lets say i want the vba to do the same but for barcelona i want to search not only for 1,95 but in a range from 1,90-2,00. Is that possible?

[Kaper]

Yes, it is.
In advanced filter use 2 criteria for given column.
one as:
>=1.90
and second
<=2.00