I am looking to populate a sheet in Excel based on filtering data from another sheet in the same workbook.
For e.g. I have below data in a sheet, I would like to populate another sheet with this data but with filter, the filter would be 'Target Company'. so if select ANZ as my target company as a drop down then the data for ANZ should get populated in another sheet. (refer table 2 for expected output).