Jan 18 2023
I'm looking to create a button using VBA to generate a table/or list of tables to list entries matching specific criterias.
The criterias are imported from Table 1 - Sheet 1
The search space is Table 2 - Sheet 2
Table 3 (or more tables) is the result
The result table should apply the criterias in Table 1 and find matching results in Table 2, all reported in a separate table.
I'm including screenshots of how it would look like for the first few entries. If no match to criteria, then blank.
TABLE 1 - CRITERIATABLE 2 - SEARCH SPACETABLE 3 - RESULTS