I do know how to autofilter but that doesn't really address my original
question. I'm not looking to filter the data in sheet1 on sheet1. Sheet1
needs to remain the master list unfiltered. The intention would be to
distribute the file containing these sheets to a number of classrooms so they
can quickly look at a sheet that contains just their room's assigned classes
as well as browse the master list to look at different rooms simultaneously.
The reason it needs to be on multiple sheets is simply that the group
receiving the lists is unlikely to know how to do something even as simple as
autofilter. I suppose I could create an array on sheet2, 3 and 4 of
something like =Sheet1!A1:D65536 and place it into columns A, B, C, and D and
then set the autofilters on those pages to exclude 0 and to only display rows
with the corresponding room number for a given sheet but that seems a bit
bloated. Is there another way to manage this?

"Sandy Mann" wrote:

You misunderstand me. I meant that you simply autofilter the data in Sheet
1. Selecting Room 120 to filter on will then show only classes in that
room, no need to use any other sheets.

I assume that you know how to Autofilter.

--
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
...
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!