Forum Discussion
FIltering Data from Other sheet
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
| Companies | Dept. | Target Company |
| ANZ | Engineering | ANZ |
| Knights | Marketing | ANZ |
| TRA | Service | ANZ |
| RNS | Engineering | TRA |
| M&E | Marketing | TRA |
| LID | Service | TRA |
| FLO | Marketing | TRA |
| Companies | Dept |
| ANZ | Engineering |
| Knights | Marketing |
| TRA | Service |
Appreciate your help.
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.
