B
buzzweetman
In my workbook, my first worksheet contains rows of text.
Each row also has category columns that a user can put an "x" in, to
mark that row as being a member of the particular category.
A contrived example: (I'll use commas here to delimit columns)
,Mammal,Bird,White
Fido,X,,
Fluffy,X,,X
Polly,X,
So...
Fido is a mammal, not a bird, and not white.
Fluffy is a mammal, not a bird, and is white.
Polly is not a mammal, is a bird, and not white.
Now I want to create 3 other worksheet tabs called "Mammal", "Bird",
and "White"
I want each of these worksheets to dynamically show only the rows for
worksheet1 that apply.
So, for example, the the Mammal worksheet would show a row for Fido and
Fluffy. The Bird worksheet would have a row for Polly. And the White
worksheet would have a row for Fluffy.
I want some users of this workbook to enter a new row in the first
worksheet, and mark the categories that apply.
Later, other users should be able to choose the Mammal, Bird, or White
worksheet tab and see only the rows that are relevant.
Can someone suggest a way(s) to do this?
Thanks for any help.
Buzz
Each row also has category columns that a user can put an "x" in, to
mark that row as being a member of the particular category.
A contrived example: (I'll use commas here to delimit columns)
,Mammal,Bird,White
Fido,X,,
Fluffy,X,,X
Polly,X,
So...
Fido is a mammal, not a bird, and not white.
Fluffy is a mammal, not a bird, and is white.
Polly is not a mammal, is a bird, and not white.
Now I want to create 3 other worksheet tabs called "Mammal", "Bird",
and "White"
I want each of these worksheets to dynamically show only the rows for
worksheet1 that apply.
So, for example, the the Mammal worksheet would show a row for Fido and
Fluffy. The Bird worksheet would have a row for Polly. And the White
worksheet would have a row for Fluffy.
I want some users of this workbook to enter a new row in the first
worksheet, and mark the categories that apply.
Later, other users should be able to choose the Mammal, Bird, or White
worksheet tab and see only the rows that are relevant.
Can someone suggest a way(s) to do this?
Thanks for any help.
Buzz