Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Designing master schedule
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 - |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Designing master schedule
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Designing Form | New Users to Excel | |||
Macro Designing | Excel Discussion (Misc queries) | |||
Designing a Form | Excel Discussion (Misc queries) | |||
designing and linking | New Users to Excel | |||
Create patient schedule based on master therapist schedule | Excel Discussion (Misc queries) |