Designing master schedule
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 -
|