Filtering a list on another page

bosko2

New Member
Joined
Nov 3, 2020
Messages
14
Office Version
  1. 365
Platform
  1. Windows
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
 

Some videos you may like

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

Watch MrExcel Video

Forum statistics

Threads
1,118,602
Messages
5,573,166
Members
412,510
Latest member
shp0590
Top