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
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