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!!