For the data table named 'Category 1' in column T, it needs to select each Category 1 substance (i.e. yellow substances 1, 2, 3, 4, 5) for which the level (given in Tables 2 and 4) is above the limit (i.e. red row). This is determined using the IF statement in Table 1, but what I need is for the data table to change sizes by retrieving the substance name, level, and limit only for the substances whose level is over the limit. It needs to be dyamic because every time the list box is used to choose a new location then the list of substances over their limit will change. I need to do this for each Category 1, 2, and 3, so showing me how to do the first will be a great help.

Thank you!

data_analysis.xlsx