Hi,

I have data in one sheet "Data", on "sheet2" I would like to be able to choose from a drop down the Dept name and have a table below populate based on the criteria.

E.G

If Dept1 is selected then display all of dept1 products and so on

The data is not in any current table format

Would anyone be able to help with this, I hTestfile.xlsxTestfile.xlsxave attached workbook of example data