Please help! I have been asked to maintain a calendar which lists calendar
items and sorts them by item type on one sheet and then links those items to
a calendar format on another sheet in the workbook.

For example:

Type Date Start Time End Time Who What Where
Comments


I was thinking a formula linking to the sheet containing the above
information which indicates if the date is = to the date on the calendar
(separate worksheet), then the remaining row of information should be entered
in that cell.

I am decent with everyday formulas, but this is beyond me and it's for my
boss.

Thank you for any help you can give!!

Send me an email to:

pashurst <at> auditel.net

(change the obvious), and I can send you back a file which does a
similar thing to what you are asking for. The file has two sheets - on
one you list activities and dates in any order, and the other sheet
displays the activities on the appropriate date in calendar format, up
to 7 per day, where you choose the month and year that is displayed
from drop-downs.

Hope this helps.

Pete

On Aug 28, 9:42*pm, Kristin <Kris...@discussions.microsoft.com> wrote:
> Please help! *I have been asked to maintain a calendar which lists calendar
> items and sorts them by item type on one sheet and then links those itemsto
> a calendar format on another sheet in the workbook.
>
> For example:
>
> Type * * * Date * * * Start Time * * End Time * * *Who * * What * * * *Where
> * * * Comments
>
> I was thinking a formula linking to the sheet containing the above
> information which indicates if the date is = to the date on the calendar
> (separate worksheet), then the remaining row of information should be entered
> in that cell.
>
> I am decent with everyday formulas, but this is beyond me and it's for my
> boss.
>
> Thank you for any help you can give!!

WOW!! You are a life saver!! I sent it to the e-mail listed. Thank you so
very much!!!!

"Pete_UK" wrote:

> Send me an email to:
>
> pashurst <at> auditel.net
>
> (change the obvious), and I can send you back a file which does a
> similar thing to what you are asking for. The file has two sheets - on
> one you list activities and dates in any order, and the other sheet
> displays the activities on the appropriate date in calendar format, up
> to 7 per day, where you choose the month and year that is displayed
> from drop-downs.
>
> Hope this helps.
>
> Pete
>
> On Aug 28, 9:42 pm, Kristin <Kris...@discussions.microsoft.com> wrote:
> > Please help! I have been asked to maintain a calendar which lists calendar
> > items and sorts them by item type on one sheet and then links those items to
> > a calendar format on another sheet in the workbook.
> >
> > For example:
> >
> > Type Date Start Time End Time Who What Where
> > Comments
> >
> > I was thinking a formula linking to the sheet containing the above
> > information which indicates if the date is = to the date on the calendar
> > (separate worksheet), then the remaining row of information should be entered
> > in that cell.
> >
> > I am decent with everyday formulas, but this is beyond me and it's for my
> > boss.
> >
> > Thank you for any help you can give!!
>
>

You're welcome - I've sent my file back to you.

Pete

On Aug 28, 11:03*pm, Kristin <Kris...@discussions.microsoft.com>
wrote:
> WOW!! *You are a life saver!! *I sent it to the e-mail listed. *Thank you so
> very much!!!!
>
>
>
> "Pete_UK" wrote:
> > Send me an email to:
>
> > pashurst <at> auditel.net
>
> > (change the obvious), and I can send you back a file which does a
> > similar thing to what you are asking for. The file has two sheets - on
> > one you list activities and dates in any order, and the other sheet
> > displays the activities on the appropriate date in calendar format, up
> > to 7 per day, where you choose the month and year that is displayed
> > from drop-downs.
>
> > Hope this helps.
>
> > Pete
>
> > On Aug 28, 9:42 pm, Kristin <Kris...@discussions.microsoft.com> wrote:
> > > Please help! *I have been asked to maintain a calendar which lists calendar
> > > items and sorts them by item type on one sheet and then links those items to
> > > a calendar format on another sheet in the workbook.
>
> > > For example:
>
> > > Type * * * Date * * * Start Time * * End Time * **Who * * What * * * *Where
> > > * * * Comments
>
> > > I was thinking a formula linking to the sheet containing the above
> > > information which indicates if the date is = to the date on the calendar
> > > (separate worksheet), then the remaining row of information should beentered
> > > in that cell.
>
> > > I am decent with everyday formulas, but this is beyond me and it's for my
> > > boss.
>
> > > Thank you for any help you can give!!- Hide quoted text -
>
> - Show quoted text -