Hello,
Attached is what I use as a Calendar Macro and it works great for single active cell use.
I have a column for 'Notes' and I can only use 1 cell per item so every time I have an update about a specific item I go the to notes section and put a date and leave few spaces then type in whatever the notes are. Currently I'm doing it manually and I tried to use my macro on the Notes column and what it does is to remove everything in the cell and replace it with whatever date I choose in the calendar.
I'm trying to see if anyone can help me find a way to use my current Calendar Macro to add a date in the cell instead replacing everything in the cell with a date.
If I didn't make a lot of sense please look to the attachment it will help clarify.
Thank you!
Bookmarks