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