Combo box filter

Hello all!

What I want to do:
1)Select Name1 or Name2 sheet (and set focus on that sheet) from Combobox1 selection
2)Combobox2 filters names (combobox 2 acts as autofilter of that sheet) based on which sheet (Name1 or Name2) that is selected

Screen Shots:
Attachment 356024
Attachment 356025
Attachment 356026

Thank you all!

Hi,

dupe to http://www.excelforum.com/excel-prog...ox-filter.html where the attachments are integrated into the threasd but no workbook there as well.

Ciao,
Holger

Hello Apollo4life,

I have closed your other thread and left a redirect to this post.

Quid pro quo. Please post a copy of your workbook. People are not inclined to try an reproduce your work. Not only is it time consuming, it is rarely true to the your original work.

Please provide before and after examples of your data along with any notes you would like to include.

If your workbook contains any sensitive information, please redact that information before you post.

How To Post Your Workbook

1. At the bottom right of the Reply window, Click the button Go Advanced
2. At the top of the Your Message Window, in the first row of icons, Click the Paperclip icon.
3. Click the Add Files button at the top right in the dialog box. This displays the File Manager dialog.
4. Click the Select Files button at the bottom middle of the dialog.
5. In the new window Find the file you want to upload, select it, and Click Open.
6. You will now be back in the File Manager dialog. Click the bottom Middle button Upload File.
7. Wait until the file has completely uploaded before you exit the File Manager dialog.