Link combobox to autofilter and goto sheet

Hi there

I have created a template for a spreasheet with combo box where when the user makes a selection, they will automatically be taken to another sheet where an autofilter will run depending on thier selection from the combo box.

I have attached my sheet below if that helps. I am hoping that the user will be able to select a product from the "Main" sheet combobox. At which point they will be taken to the "Product" sheet where column B (Product) will have filtered to show thier selection.

Any help would be great
Thanks

If you add a cell link to your combox, e.g. C1 in Lists, and then add this formula, e.g. in D1 in Lists

=INDEX($A$1:$A$32,C1)

then try this code:

Please Login or Register  to view this content.

hello how do i make this combo box to just take me to another sheet