Hi guys, Can you please help me with a really easy thing?
What I would like is to createa filter for my data. The data is structured like this:
Country manager | company name | city | blablabla other details
I have a big database for these company details, but on the first tab of the excel I just want to show the details of 1 company.
There should be 1 dropdown for names, and after a second dropdown which only shows the companies of the chosen Country manager.
How should I do this? Should I use macro for this, or even with a pivot and data validation I can manage it?
PS:
The second part of the whole story will be that I want to have some data input on this first page, which would eventually get written back to this database from where the original data is, but that will be done with macro, but only later.
Please help! Thanks!
What I would like is to createa filter for my data. The data is structured like this:
Country manager | company name | city | blablabla other details
I have a big database for these company details, but on the first tab of the excel I just want to show the details of 1 company.
There should be 1 dropdown for names, and after a second dropdown which only shows the companies of the chosen Country manager.
How should I do this? Should I use macro for this, or even with a pivot and data validation I can manage it?
PS:
The second part of the whole story will be that I want to have some data input on this first page, which would eventually get written back to this database from where the original data is, but that will be done with macro, but only later.
Please help! Thanks!
