Creating a button that generates a table listing entries from other sheets to match criteria

Copper Contributor

Hi,

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 1 - CRITERIATABLE 2 - SEARCH SPACETABLE 2 - SEARCH SPACETABLE 3 - RESULTSTABLE 3 - RESULTS

 

 

0 Replies