Sep 25 2021 03:03 PM
Not really experienced in excel and especially when it comes to formulas, so bear with me please.
I'm trying to edit the following template so that instead of the text "Assignment due!" appearing in the appropriate cell in the monthly view sheet, a reference to the content of the matching assignment description appears in the cell.
So for example if I fill in the following information in the assignments sheet: description: Physics Exam, date: 25/10/2021, I'd like the words "Physic Exam" to appear in the cell allotted to October 25th in the monthly view sheet.
https://www.dropbox.com/s/wq9syiuoqfe8dd6/TF034580771_intl.xltx?dl=1
(original template belongs to microsoft, template modified by Andreas Killer)
Thanks in advance for your help and time!
Sep 25 2021 06:08 PM
SolutionSep 25 2021 10:23 PM
@Riny_van_Eekelen Thank you very much! This is exactly what I needed.
Sep 25 2021 06:08 PM
Solution