Hello Beautiful People,
I'm wondering if there's a way to have a product name, which is currently recorded in a column showing the date it goes out and the date it's due back..... to have those names populate onto a calendar on a separate tab?
For example, as the order comes in, it is recorded on the next line with the product name, date out and date due, but my problem is the due dates arent necessarily in chronological order, so it's hard for me to easily see whats due next. I'm hoping that a formula, when a date is populated in column D, it will automatically populate onto the next tab, in the correct cell of the calendar for the date. Does that make sense?
I've included a sample of what I'm needing. Thanks for any help!!
Bookmarks