I can't figure out how to make this work. I have the drop down box/cell.
How do I get it to copy the information on sheet 1 to the master sheet? Any
formula I try gives me an error.
--
Kelli


"Pete_UK" wrote:

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