Perhaps one formulas option which delivers it the way you want ..

Try this sample construct from my archives:
http://www.savefile.com/files/430142
AutoCopy Lines to Resp Sht Non Array.xls
(Full details inside, nicely rendered. Easy to adapt ..)

Data is continuously entered in a master ("parent") sheet, with lines neatly
auto-copied to each individual ("child") sheet based on the values within a
key col.

In the sample, the key col in the master sheet is the "State" col, which may
contain eg: NY, CA, NV, SD, AZ, etc. All lines with "NY" in the key col will
be auto-copied to the sheet named: NY, and appear neatly bunched at the top.
Ditto for lines with "CA", "NV", etc which will be copied into their
respective sheets.

Propagation of the "child" sheet is as simple as making a copy of the
initial one, then renaming it accordingly as the next key col value. Eg we
first formulate one child sheet for "NY", dress it up nicely, then just make
copies of the "NY" sheet, and rename these as: CA, NV, SD, etc.

In your case, the key col would be the "Room" (col B), eg: 120, 255, 310,
etc
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Furlong" wrote:
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!