FIltering Data from Other sheet

Deleted
Not applicable

Hi,

 

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).

 

Table 1

CompaniesDept.Target Company
ANZEngineeringANZ
KnightsMarketingANZ
TRAServiceANZ
RNSEngineeringTRA
M&EMarketingTRA
LIDServiceTRA
FLOMarketingTRA

 

CompaniesDept
ANZEngineering
KnightsMarketing
TRAService

 

Appreciate your help. 

 

1 Reply

@Deleted 

Depends on your Excel version / platform and what you'd like to do with returned data. As variants that could be FILTER function (microsoft.com) or Power Query.