How to Auto populate via drop down selection

[Albert Truncation]

Hi everyone,

I am using Office 365 for Business.

I have a "Work in Progress" table that I would really love to be able to simplify. It has among other things Employee, Department, Current work, notes. I am wanting to make it so I can select the Employee from a drop down box and it will auto populate all the current work they have on. This will encompass the same employee over different departments as well.
I am hoping to get to a result that when I choose an employee it will list all rows in a worksheet that has their name in it.

I will eventually want to do the same with the Department so I can list all the current work in a department but I'm picking replicating the solution for Employee will do the same.

Can someone point me in the direction to how to get this done please.

Cheers

[shg]

How about just Autofilter?

[Albert Truncation]

Hi shg,

Thanks for the reply. I had never had a play with auto filter before so thanks for bringing it to my attention. However I don't think it is quite what I was looking for.

From what I could gather you can only use auto filter once per work sheet so would have to set it up each time I want to change filters.

Hopefully this final sheet will be able to be used by all employees to see what is going on around the place so preferably I would like to have an option on a separate worksheet where I can just use a drop down box to choose a filter and then it will display all entries relating to that option from off of another worksheet.

[vcoolio]

Hello Albert,

You more than likely could use Advanced Filter set up on another sheet. A simple code for this would be as follows:-

Please Login or Register  to view this content.

It assumes that your range covers Columns A:G. It would need to be set up as in the sample file that I've attached for you to play with.
The source data is in Sheet1 and the searches are done in Sheet2.
For the sake of the exercise, I've set up data validation drop downs just in cells B2, D2 and G2. Data searches will be done on the values that you pick from the drop downs. You can use just one data validation drop down or you can use them all at once. It will depend on what criteria you wish to search on. Once you've made your selections, click on the"GO" button.

Test it in a copy of your workbook.

I hope that this helps.

Cheerio,
vcoolio.

[Albert Truncation]

Good morning vcoolio,

That is exactly what I was hoping to achieve, however I now realise that it is way more advanced than I thought as I don't really understand how to get the end result. Will keep playing with it and see what i can work out.

Thanks for the answer anyway, at the very least it shows me it is achievable.

[vcoolio]

You're welcome Albert. I'm glad that it has started you off in the right direction.

Don't be afraid to ask more questions. If you do, it would be a good idea to upload a sample of your workbook so that we can see what you are up to. If you do upload a sample, please use dummy data.

Cheerio,
vcoolio.