Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Good day all

I have a table on a worksheet with two columns (name/ID). each column has a drop downlist data. I want to filter one column by using other drop down list.

for example when I choose a name from list in the column (name) must the other column filterd to match the selection.

Best regards,

share|improve this question

migrated from stackoverflow.com Nov 17 '11 at 11:41

This question came from our site for professional and enthusiast programmers.

1 Answer 1

What is your Excel's Version ?

You have to select the Column Headers and click on "Data", "Filter" and "automatic filter" for XL2003 "Data", "Filter" for XL2007 and probably 2010.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.