That would be great Pete
Thank you

"Pete_UK" wrote:

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

On Oct 3, 7:51 pm, GeorgeR wrote:
POssibly, it would work like an appointment calendar similar to Outlook



"Bernie Deitrick" wrote:
George,

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

HTH,
Bernie
MS Excel MVP

"GeorgeR" wrote in message
...
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.- Hide quoted text -

- Show quoted text -