Filtering Two Worksheets

chris_marconi

New Member
Joined
Jun 27, 2005
Messages
6
Dear Reader

Is there a way to filter between two separate worksheets where by the first worksheet drives the value of the second?

For example, both worksheets contain address / city / state / zip in separate colums. I'm hoping to configure this so that when I click on a city / state in the primary worksheet, excel auto - filters the second worksheet based on the value I have highlighted in the primary.

Any help would be greatly appreciated.

best regards
Chris
 

Some videos you may like

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

Watch MrExcel Video

Forum statistics

Threads
1,118,520
Messages
5,572,621
Members
412,475
Latest member
JaredNAU
Top