Filter table on separate sheet

[EmilyB]

Hello,

I've got an excel worksheet that contains a list of buildings and their associated control valves for water supply (subset of table attached).

I'd like the user to be able to search by building name to display its associated valves and control information. I realize I could use the list function on the worksheet, but would prefer to set it up as front page to the workbook where data is displayed in a nicer format.

I guess my question is if there any way I can set up another worksheet with a drop down box that allows the user to select a building or type in the building name and have its corresponding data display?

Thanks heaps for your help!!!

Cheers,
Emily

[davesexcel]

Try this code in your example,
This goes in the WorkSheet module, Right click on the sheet tab and select view code

Please Login or Register  to view this content.

This goes in a regular module

Please Login or Register  to view this content.

Make a selection from the Data Validation dropdown in A1 Sheet1, to activate the code.

Here is your example.

[EmilyB]

Hi Dave,

Sorry it's taken me a while to thank you for your help - I have been off work since posting!

That is exactly what I needed and I appreciate the time you took to put that together.

Thanks again,

Emily

[Quinn Barrows]

What if I wanted multiple auto filters? If I wanted to continue to narrow my search? Using your example, I would also like to filer by column 5 in the data table.

I am in need of multiple filters searching through a large table which displays limited columns from table on a seperate sheet.

Any help would be greatly appreciated.

[arlu1201]

Quinn,

Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.