This is the end result I'm working towards if it's even possible:
I'm trying to create an excel doc where on one tab, I can list out various orders, along with ship dates and delivery dates, and on a separate tab have a condensed calendar showing several months, and the ship dates and delivery dates populate as appointments. Basically, I want a visual snap shot of when multiple orders for a single project are shipping and arriving so install timelines are more easily established. To then make it even more complex, it would be ideal that instead of having a calendar where you just specify year and it shows the 12 months of that year, I want to be able to specify what month to start on (for those projects that may start in September of one year and run through April of the next).
Here is my actual question:
There is an excel calendar called College Year Calendar, and while I can typically dissect an existing document to see how it works and then apply that to what I'm trying to do, I can't figure out how this works. Additionally, if I try and change any values, it doesn't seem to actually work. Can someone please explain how they were able to have appointments listed in one tab, and make it mark the calendar and populate the list of appointments for that day to the right? Any and all help is GREATLY appreciated. I have been trying to utilize Google to find some answers on my own, but must not have the right search terms as I'm not finding any helpful results.
Thank you!
I'm trying to create an excel doc where on one tab, I can list out various orders, along with ship dates and delivery dates, and on a separate tab have a condensed calendar showing several months, and the ship dates and delivery dates populate as appointments. Basically, I want a visual snap shot of when multiple orders for a single project are shipping and arriving so install timelines are more easily established. To then make it even more complex, it would be ideal that instead of having a calendar where you just specify year and it shows the 12 months of that year, I want to be able to specify what month to start on (for those projects that may start in September of one year and run through April of the next).
Here is my actual question:
There is an excel calendar called College Year Calendar, and while I can typically dissect an existing document to see how it works and then apply that to what I'm trying to do, I can't figure out how this works. Additionally, if I try and change any values, it doesn't seem to actually work. Can someone please explain how they were able to have appointments listed in one tab, and make it mark the calendar and populate the list of appointments for that day to the right? Any and all help is GREATLY appreciated. I have been trying to utilize Google to find some answers on my own, but must not have the right search terms as I'm not finding any helpful results.
Thank you!
