I have an old macro that lets me do an advanced filter on a table orginating in SQL.
Because of a change in the values in the field i need to use wildcards.
Before i had values like below
Category
SmG
SmG/LTM
SmG/Trade
This was handlet with a filter that gave me all those with:
Category
SmG
New values are like: SmE/SmG/LTM and SmE/SmG/Trade. How do i get it to still search for SmG (but not just from the beginning of the value?)
Appriciate any help
Because of a change in the values in the field i need to use wildcards.
Before i had values like below
Category
SmG
SmG/LTM
SmG/Trade
This was handlet with a filter that gave me all those with:
Category
SmG
New values are like: SmE/SmG/LTM and SmE/SmG/Trade. How do i get it to still search for SmG (but not just from the beginning of the value?)
Appriciate any help
