View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Syahira
 
Posts: n/a
Default how to sum up or count based on dates

Let say I have this file will multiple sheets: Bob, Adam, Shiela

This example in Bob sheet:

Date Activities Venue
3/19/2006 Parents Meeting Branch
3/25/2006 Area Meeting A HQ
4/3/2006 Clients Orientation Branch
5/11/2006 Team Meeting HQ

Adam:

Date Activities Venue
2/8/2006 Clients Oreintation Branch
3/25/2006 Area Meeting B HQ
4/17/2006 Team Meeting HQ
4/28/2006 Staff Training HQ

How to make a summary in a different page based on
dates/activities/Venue/name?

Thank You (^_^)