F
Furlong
I've been struggling with this for a while now trying to figure this out on
my own. Having found no success I finally broke down and decided to ask for
help.
What I'd like to do is create worksheets that contain lists based on the
content of a master list on a separate worksheet. Let's say Sheet1 (the
master list) contains a four column list of classes, with corresponding room
numbers, teacher names, and start time. It might look something like this:
CLASS ROOM TEACHER START
Language 120 Stanley 900
Government 255 Hart 1020
Art 310 Bloom 1115
Math 255 Smith 1300
Science 310 Jones 1435
History 120 Bolt 1600
And then on Sheet2 I want to display all the classes held in Room 120 with
corresponding data from Sheet1, Sheet3 all the classes held in Room 255, and
Sheet4 all the classes held in room 310. Is there a way to write a formula
that will generate such lists in each of these sheets? I was thinking maybe
somehow using an array but I'm not sure how to got this to work properly. I
should also mention that I would need to have the lists on Sheet2, 3, and 4
be flexible enough that if the data grows or shrinks in terms of number of
entries that would correspond to those pages that those pages will grow and
shrink as well (in other words if I add five more classes to the master list
being held in room 120, Sheet1 will simply add them to the list it displays
and if I take two of the classes currently held in room 255, Sheet3 will
reflect that change as well).
In all honesty I'm not working with class lists but rather with long lists
of data generated by a project on which I'm currently working. I chose the
class list example to try to simplify my question. It still looks a bit
complex to me but hopefully you'll be able to read past that and still be
able to help me out. Thanks so much in advance!
my own. Having found no success I finally broke down and decided to ask for
help.
What I'd like to do is create worksheets that contain lists based on the
content of a master list on a separate worksheet. Let's say Sheet1 (the
master list) contains a four column list of classes, with corresponding room
numbers, teacher names, and start time. It might look something like this:
CLASS ROOM TEACHER START
Language 120 Stanley 900
Government 255 Hart 1020
Art 310 Bloom 1115
Math 255 Smith 1300
Science 310 Jones 1435
History 120 Bolt 1600
And then on Sheet2 I want to display all the classes held in Room 120 with
corresponding data from Sheet1, Sheet3 all the classes held in Room 255, and
Sheet4 all the classes held in room 310. Is there a way to write a formula
that will generate such lists in each of these sheets? I was thinking maybe
somehow using an array but I'm not sure how to got this to work properly. I
should also mention that I would need to have the lists on Sheet2, 3, and 4
be flexible enough that if the data grows or shrinks in terms of number of
entries that would correspond to those pages that those pages will grow and
shrink as well (in other words if I add five more classes to the master list
being held in room 120, Sheet1 will simply add them to the list it displays
and if I take two of the classes currently held in room 255, Sheet3 will
reflect that change as well).
In all honesty I'm not working with class lists but rather with long lists
of data generated by a project on which I'm currently working. I chose the
class list example to try to simplify my question. It still looks a bit
complex to me but hopefully you'll be able to read past that and still be
able to help me out. Thanks so much in advance!