Hmm... interesting. Tell me more. What do I need to do in Sheet2 to
autofilter the list from Sheet1 to only show the classes listed in Room 120?
Thanks!

"Sandy Mann" wrote:

If your real data sufficiently resembles your example, why not just use
Autofilter to filter the data in sheet 1 to show only what you want?

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Furlong" wrote in message
...
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!