If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Calendar List to Calendar format
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!! |
#2
|
|||
|
|||
Calendar List to Calendar format
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!! |
#3
|
|||
|
|||
Calendar List to Calendar format
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!! |
#4
|
|||
|
|||
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 - |
Thread Tools | |
Display Modes | |
|
|