Wildcard Operators in VBA

[bino1121]

I have a workbook going right now that has 2 sheets. Sheet1 is a data set. Sheet2 is a list of buildings. So far I have it so that the advanced filter is used so that the dataset on Sheet1 is filtered based on the values in Sheet2. My question is can I some how incorporate a line of code to make it so that Wildcards can be used so that only the exact values will be returned and not values that include part of it? For example: I want to filter out only building 1. But I have Building1, Building1A, Building1B, Bulding1C in my list. In the case of my current code the filter will return all those values when I filter by building1. Using wildcards I could get the exact building when filtering to be just Building1.

 

[Artik]

Try to build an advanced filter that follows the pattern in the image.

Artik

 

[bino1121]

Try to build an advanced filter that follows the pattern in the image.

View attachment 91035

Artik

I don't think this will work as I am advanced filtering Sheet1 based on the values in Sheet2

 

[Artik]

For now, I have given you a hint on how to build a filter criterion. As you can see in the image, the criterion is not the cell into which you write the text you are looking for, but a formula (in cell G2) that compares the text you entered (cell E1) with the first cell of the source data (cell A2). When using formulas as a filtering criterion, the criterion's header row should be left blank or contain a name that does NOT appear in the headers of the source table.

If you have trouble adapting my hint attach a workbook with the actual data layout (but change the sensitive data). Since this forum does not allow you to add workbooks as attachments to a post you will need to make the workbook available in some other way, such as through OneDrive or other hosting.

Artik