Hi there, I have two pages, the first page requires the user to select their positon within the company (There's three filters) and then press a button "Generate Report". I have the vba for the new report page, it takes what is on page 2, then creates a page 3, then hides and resets page 2. My problem is hooking my Excel dropdowns to the master list, the below is far as I could get: Sub FilterRows_Investigations() Worksheets("Investigations data").Range("A1").AutoFilter Field:=14, Criteria1:=("SEQ") Worksheets ("Investigations data").Range ("A1").Autofilter Field:=16 Criterial:="Drop Down 8" This brings back SEQ in the first column, because I put it there myself, however I want to get the value (like the one below it) from a dropdown box. Let me know what you guys think? End Sub

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Filtering a list on another page

Thread starter bosko2
Start date Nov 3, 2020

bosko2

New Member

Nov 3, 2020

Hi there,

I have two pages, the first page requires the user to select their positon within the company (There's three filters) and then press a button "Generate Report". I have the vba for the new report page, it takes what is on page 2, then creates a page 3, then hides and resets page 2.

My problem is hooking my Excel dropdowns to the master list, the below is far as I could get:

VBA Code:

Sub FilterRows_Investigations()

Worksheets("Investigations data").Range("A1").AutoFilter Field:=14, Criteria1:=("SEQ")
Worksheets ("Investigations data").Range ("A1").Autofilter Field:=16 Criterial:="Drop Down 8"


This brings back SEQ in the first column, because I put it there myself, however I want to get the value (like the one below it) from a dropdown box.

Let me know what you guys think?
End Sub