I'll start by saying I'm a novice VBA user, but can copy/paste/modify existing code well enough
- On worksheet "B", I have a table of data with:
- Row 1 = Title row
- Row 2 = Column Headers (State, City, Metric1, Metric2, Metric3)
- Rows 3-5000 = Data
- On worksheet "C", I have a table of data with:
- Row 1 = Title row
- Row 2 = Column Headers (State, City, Metric4, Metric5, Metric6)
- Rows 3-8000 = Data
- I have both worksheets B & C set up on AutoFilter
- Because there are hundreds of cities in the data and it's a pain to use the auto-filter dropdown, I'd like to do the following instead:
- On worksheet "A", put "State" in Cell A1 and have the user type the State they want to see in Cell A2
- They would then go back to worksheets B & C and see only rows with that State
- I'd also put "City" in cell B1 and have the user type the City they want to see in Cell B2
- The AutoFilter on worksheets B & C would filter when either A!A2 or A!B2 is populated (double filter if both are populated)
- If A!A2 or A!B2 are not populated, then the corresponding column would not be filtered
- On worksheet "B", I have a table of data with:
- Row 1 = Title row
- Row 2 = Column Headers (State, City, Metric1, Metric2, Metric3)
- Rows 3-5000 = Data
- On worksheet "C", I have a table of data with:
- Row 1 = Title row
- Row 2 = Column Headers (State, City, Metric4, Metric5, Metric6)
- Rows 3-8000 = Data
- I have both worksheets B & C set up on AutoFilter
- Because there are hundreds of cities in the data and it's a pain to use the auto-filter dropdown, I'd like to do the following instead:
- On worksheet "A", put "State" in Cell A1 and have the user type the State they want to see in Cell A2
- They would then go back to worksheets B & C and see only rows with that State
- I'd also put "City" in cell B1 and have the user type the City they want to see in Cell B2
- The AutoFilter on worksheets B & C would filter when either A!A2 or A!B2 is populated (double filter if both are populated)
- If A!A2 or A!B2 are not populated, then the corresponding column would not be filtered