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

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

Watch MrExcel Video

Forum statistics

Threads
1,118,058
Messages
5,569,957
Members
412,300
Latest member
Chaneycr
Top