So, from this forum (thank you!), I have a dynamic calendar on one worksheet that populates data from another worksheet. This is exactly what I was looking for, but I need to edit the workbook to fit my needs.
The attached files are the production schedule ("Metal Production") that I am creating, and the aforementioned calendar workbook ("Demo Calendar") I started to edit.
(I took out the addresses from Metal Production for sake of privacy.)
My goals are to get the function of auto population in Demo Calendar ported to Metal Production, OR the format of the Metal Production ported to Demo Calendar (whichever is easier).
I only need the "PO: Name" to populate into the calendar, and of course I would need the date to extend over the range ("Start Date" to "End Date").
I would also like to change to calendar to grey out the days of other months (instead of black out), and maybe color code the jobs based on crew. However, the color code may not be necessary if it could populate the calendar in order based on the crew (i.e. the same crews are 1st, 2nd, etc. on the calendar day).
Bookmarks