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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Filtering multiple worksheets in one workbook 5
Viewing other worksheets in a main worksheet 10
filter two worksheets w/ the first as a controller 3
Autofilter with Locked/Protected worksheets 1
Creating sheet and copying filtered rows in it 3
Vlookup or something more? Trying to make the book intuitive... 7
Quick VBA Worksheet Change Event or Selection Question: 1
Using Filters in Excel 2000 5

Back
Top