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


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

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.

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 -

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 -