advanced filtering vba picks up wild cards?

[daveyc18]

so i have in column A...booking point...and under that...x376x, x324x....

in column B, i have product type....under that, TR Swap

for whatever reason, when i pull this data in using a vba macro based on the criteria above, it's also pulling in booking point "x324xVAL," but i dont want that...i only want "x324x" ....how come it's pull that in, too?

i thought for the criteria, what you type has to be exact and if you wanted variability, you'd use wild cards (e..g, x324x*)

 

[Fluff]

Care to post the code your using?

 

[RoryA]

i thought for the criteria, what you type has to be exact and if you wanted variability, you'd use wild cards (e..g, x324x*)

No, with an advanced filter the default is match anything that starts with your criterion. If you want an exact match, you have to use =x324 in a cell formatted as text, or ="=x324" as a formula in a general formatted cell.

 

[daveyc18]

No, with an advanced filter the default is match anything that starts with your criterion. If you want an exact match, you have to use =x324 in a cell formatted as text, or ="=x324" as a formula in a general formatted cell.

doing as text worked...ie without using the quotes

thank you

 

[RoryA]

Glad to help.