Calendar

  • Thread starter Thread starter GeorgeR
  • Start date Start date
G

GeorgeR

Does anyone know of a calendar or planner out there that when a date is
entered on a worksheet, it could take the date and time info and neter it on
the appropriate date on the calendar embedded in another worksheet?
Been trying to figure that one out for a while now. All help is very much
appreciated.
 
George,

Do you want more than one entry on any given date?

HTH,
Bernie
MS Excel MVP
 
I did one some time ago for another poster where you have a list of
activities on one sheet (in any order) and the calendar on another
sheet where you can select the month and year from drop-downs and the
calendar automatically populates from the activities sheet. Up to 7
activites per day could be displayed, though it did not pick up time
information.

I then developed it into a weekly planner (specify week number on the
planner sheet) and it shows up to 5 activities per hour block through
a normal working day. You have to specify date, time and event details
on the activies sheet.

If you want a copy of either of these send me an email to:

pashurst <at> auditel.net

Change the obvious.

Pete
 
That would be great Pete
Thank you

Pete_UK said:
I did one some time ago for another poster where you have a list of
activities on one sheet (in any order) and the calendar on another
sheet where you can select the month and year from drop-downs and the
calendar automatically populates from the activities sheet. Up to 7
activites per day could be displayed, though it did not pick up time
information.

I then developed it into a weekly planner (specify week number on the
planner sheet) and it shows up to 5 activities per hour block through
a normal working day. You have to specify date, time and event details
on the activies sheet.

If you want a copy of either of these send me an email to:

pashurst <at> auditel.net

Change the obvious.

Pete
 
Back
Top