VBA to filter a table based on a range.

[madvogue29]

Hi team I have a table on Sheet 1 and some values on sheet 2 column E
Is there a way i can filter the table in sheet one to display content only if Column A in the table matcehs the values from Sheet 2 column E .

I hope this want too confusing

Thanks in advance

 

[Joe4]

I would recommend looking into using the new FILTER function, as shown here: FILTER function - Microsoft Support
You just need one single formula, which will spill over to return multiple rows and columns. You can reference your data on Sheet1, and filter condition from Sheet2 right in the formula.