Designing master schedule

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

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

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

Hi Kelli,

send me an email to:

pashurst at auditel.net

(change the obvious), and I'll send you a file which might do just
what you are hoping for. Let me know the names of the children so I
can customise it for you.

Pete

On Sep 15, 3:05*am, Kelli Jordan
wrote:
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- Hide quoted text -

- Show quoted text -

Kelli,
Here is a template that I created to help you. You can download it at:

http://tinyurl.com/r3r9fu

--
Add MS to your News Reader: news://msnews.microsoft.com
Rich/rerat
(RRR News) message rule
Previous Text Snipped to Save Bandwidth When Appropriate


"Kelli Jordan" wrote in message
...
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