Excel 2000 - Filter/multi worksheets question

  • Thread starter Thread starter Laura
  • Start date Start date
L

Laura

I created a spreadsheet to be used by Management, Scheduling an
Training within a call center. Each department has their own sheet bu
most will need to *View* more than one sheet.

Is there a way to make it so that when they filter the first workshee
all of the other worksheets also filter by the same column(s
automatically?
:confused:



-Always remember to pillage before you burn.-
 
In that case why wouldn't you leave the data all on one sheet and use the
filters there? As long as you add a dept code then they can still filter on
that to get just their dept data if they want. There is obviously no problem
with them seeing the other depts data, so why split it at all?

Also, have you considered a PivotTable for this perhaps?
 
Back
Top