Calendar List to Calendar format
You're welcome - I've sent my file back to you.
Pete
On Aug 28, 11:03*pm, Kristin
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 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!!- Hide quoted text -
- Show quoted text -
|