View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Designing master schedule

I would suggest having one sheet for the activities, where you record
the child/date/time/event and then another sheet for the schedule
where you can show the activites on a calendar-type display. On this
sheet you can have a pull-down to select the month and year, and
another pull-down to select the child, so you can either have a
monthly calendar showing all activities, or one per child.

Hope this helps.

Pete

On Sep 14, 12:28*am, Kelli Jordan
wrote:
Hi - hopefully someone will be able to help me setup my family schedule. *

I am using Excel 2007.

I am wanting to create a master schedule of my childrens activities so I
don't miss an event and can quickly see the conflicts of times/days.

Sheet one - Master schedule
Sheet two - child 1 schedule - day/time/event
Sheet three - child 2 schedule - day/time/event
Sheet four - *child 3 schedule - day/time/event
Sheet five - child 4 schedule - day/time/event
Sheet six - child 5 schedule - day/time/event
Sheet seven - child 6 schedule - day/time/event

What is the easiest way to import each childs sheet into the master sheet? *
Do I use functions? Suggestions?

Thanks in advance for your help
--
Kelli