I have a data base of over 16k columns. Each column is identified by an ID. I am trying to make an automated daily report. The data is updated every day. I have 1 sheet which is (data) sheet. I am planning on making a (report) sheet. The rows in each column is like :
ID | Name | country | Position
I am planning on making different reports, but for this example it's a report for whoever is from America and is in a Manager Position as shown here:
| Id | Name | Country | Position | |
|---|---|---|---|---|
| 131 | Jhon | America | Manager | |
| 918 | Smitg | Britain | Sampler | |
| 519 | Nnasa | America | Manager |
The report should be like
| Id | Name | Country | Position | |
|---|---|---|---|---|
| 131 | Jhon | America | Manager | |
| 519 | Nnasa | America | Manager |
New columns are added or deleted from time to time and are updated daily.
I appreciate the help
I have excel 2016