Hello, hope you are doing good. I need some help! I have a dream lol
I would like to have one Excel Master workbook where the first page is Lines of Data pertaining to projects starting with a close date. This close date can change many times. I want to manually input data in this sheet. Then I want that Date to Auto fill 2 columns into a Calendar on the next tab sheet so I have a visual of when projects are due. The two columns of data will be Project name and time that it closes- See below images. I want to enter data into first tab then have it automatically populate the project and due time in the calendar tab on the correct date. When the date changes and I input new date into first tab, it automatically moves it into the correct updated date close in the calendar. Is there a way to do this kind of magic? Thank you for any help!
Sheet 1
Sheet 2
I would like to have one Excel Master workbook where the first page is Lines of Data pertaining to projects starting with a close date. This close date can change many times. I want to manually input data in this sheet. Then I want that Date to Auto fill 2 columns into a Calendar on the next tab sheet so I have a visual of when projects are due. The two columns of data will be Project name and time that it closes- See below images. I want to enter data into first tab then have it automatically populate the project and due time in the calendar tab on the correct date. When the date changes and I input new date into first tab, it automatically moves it into the correct updated date close in the calendar. Is there a way to do this kind of magic? Thank you for any help!
Sheet 1
Sheet 2