Basically, I have a worksheet with various cities that I will be visiting every 6 months. In planning for my visits, I'd like to enter the dates on my worksheet, which in turn populates my calendar automatically. I'd like to be able to shuffle cells and values (dates) on my worksheet and have the calendar automatically update those changes in real time.
In addition, you'll see on my example in the month of January, I visited Dallas on the 8th and Denver on the 10th. I'd like those days to reflect the city visited and the "City Ep.." selection from the top my worksheet - does that make sense?
So later, on July 10th when I return, I'd like that date box to show "City Ep. 2 Dallas" from the corresponding cells on the worksheet.
Thanks for any assistance,
Bookmarks