Calendar

[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.

 

[Bernie Deitrick]

George,

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

HTH,
Bernie
MS Excel MVP

 

[GeorgeR]

POssibly, it would work like an appointment calendar similar to Outlook

 

[Pete_UK]

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

 

[GeorgeR]

That would be great Pete
Thank you

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