Before I ask my question I want to point out I am very aware of other programs, such as Outlook, that can perform the tasks I am inquiring about. I could explain in length why I do not want to use another program, but just let it be known that I don't. I am merely interested in finding out if this can be done using excel and how one would go about doing it.
I have a calendar in excel, and on one worksheet it shows the entire year. I was curious is it possible to:
- Show the current date highlighted on the the calendar.
- add a note section to the calendar, on the right hand side. So if you click on a date, you will see that dates "Notes", which you will be able to add or edit notes as needed
I have thought about several ways that one may accomplish this, but I am not sold on any yet. I have thought about creating 365 worksheets and naming them each a day of the year, and have a macro bring the data to the cells that I want (the Note section), when a specific date is selected, but again, I am still unsure if this would work.
For examples, see the attachment, you will see I have a front page. Which Technically is all that I would want to be visible, then I give example of the front page, when different cells are clicked on...
As always any thoughts, ideas suggestions are appreciated...
also if you think this is impossible let me know, thanks
Bookmarks