View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default Connecting Worsheets when there is a filter

Hi!

I am wondering how I can have one worksheet illustrate whatever I
filter on another worksheet. I have a worksheet that illustrates
Vacation time for Employees over a year. There is a filter on this
sheet so that I can pick a date and see what the totals are. I would
like to have whatever I filter connected to another worksheet. Any
suggestions?

Thanks,

Carla