G
Guest
I have two datasheets, one with three different headings, e.g. A
B
C
The other datasheet has a number of different entries, but with one of the
headings next to them, e.g. Egg A
Apple A
Custard B
Milk C
If I select 'A' on the first datasheet, I want the second one to display
only the values relevant entries to 'A'.
Autofilter will obviously do a great job of splitting my entries into 3
types, but how can I invoke autofilter automatically based on the heading I
choose from the first datasheet?
Any advice gratefully received.
B
C
The other datasheet has a number of different entries, but with one of the
headings next to them, e.g. Egg A
Apple A
Custard B
Milk C
If I select 'A' on the first datasheet, I want the second one to display
only the values relevant entries to 'A'.
Autofilter will obviously do a great job of splitting my entries into 3
types, but how can I invoke autofilter automatically based on the heading I
choose from the first datasheet?
Any advice gratefully received.