Help with Lists (tables), Filters, & Worksheets

[hhalpern]

I'm hoping that I'm just missing something and somebody out there can help
me. I'm using Excel 2007, but I'm trying to do something that would also be
backwardly compatible.

I've used the table (list) function to create a list of campers & associated
data for my son's summer camp. What we want to do is have tabbed worksheets
within the workbook that shows that data in different views. So, for
instance, the first tab is the master list, but the second tab is filtered
for the kids in the 1st session youngest class, the third tab is filtered for
the kids in the 1st session middle class, etc.

So the question is whether you can do 1 of 2 things: (1) create the filtered
list in the new worksheet, or (2) keep an linked/updated copy of the master
list on each new worksheet with different filters. Thus far, I've been unable
to figure out either option.

Yes, I know that Access would be better suited to doing this, but it's a
little bit of overkill and I'm not sure that the school is licensed for
access. Also, they've just been typing these lists into excel in the past, so
I'm just trying to be more efficient with the tool they're already using.

Thanks. -- Hugh

 

[Bernard Liengme]

In general it is poor design to have the same data more than once in a
model.
Why not just filter (Data | AutoFilter) each time you want to view the data?
For example, you can filter the data to see only 1st session campers
best wishes

 

[hhalpern]

While I agree, I think it's a usability issue. If it's not feasible, I'll
figure something else out, but I was just trying to figure out if there was a
way to do it.