Editing a calendar template in Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2785325%22%20slang%3D%22en-US%22%3EEditing%20a%20calendar%20template%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2785325%22%20slang%3D%22en-US%22%3E%3CP%3ENot%20really%20experienced%20in%20excel%20and%20especially%20when%20it%20comes%20to%20formulas%2C%20so%20bear%20with%20me%20please.%26nbsp%3B%20%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20trying%20to%20edit%20the%20following%20template%20so%20that%20instead%20of%20the%20text%20%22Assignment%20due!%22%20appearing%20in%20the%20appropriate%20cell%20in%20the%20monthly%20view%20sheet%2C%20a%20reference%20to%20the%20content%20of%20the%20matching%20assignment%20description%20appears%20in%20the%20cell.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20for%20example%20if%20I%20fill%20in%20the%20following%20information%20in%20the%20assignments%20sheet%3A%20description%3A%20Physics%20Exam%2C%20date%3A%2025%2F10%2F2021%2C%20I'd%20like%20the%20words%20%22Physic%20Exam%22%20to%20appear%20in%20the%20cell%20allotted%20to%20October%2025th%20in%20the%20monthly%20view%20sheet.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.dropbox.com%2Fs%2Fwq9syiuoqfe8dd6%2FTF034580771_intl.xltx%3Fdl%3D1%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Fwww.dropbox.com%2Fs%2Fwq9syiuoqfe8dd6%2FTF034580771_intl.xltx%3Fdl%3D1%3C%2FA%3E%3C%2FP%3E%3CP%3E(original%20template%20belongs%20to%20microsoft%2C%20template%20modified%20by%20Andreas%20Killer)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance%20for%20your%20help%20and%20time!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2785325%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2785425%22%20slang%3D%22en-US%22%3ERe%3A%20Editing%20a%20calendar%20template%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2785425%22%20slang%3D%22en-US%22%3EHave%20a%20look%20at%20the%20attached%20thread.%20Scroll%20down%20for%20the%20solution%20I%20gave%20there.%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Ftask-list-that-transfers-to-calendar%2Fm-p%2F2763702%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Ftask-list-that-transfers-to-calendar%2Fm-p%2F2763702%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
New Contributor

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!

 

 

 

 

2 Replies
Have a look at the attached thread. Scroll down for the solution I gave there.

https://techcommunity.microsoft.com/t5/excel/task-list-that-transfers-to-calendar/m-p/2763702


@Riny_van_Eekelen Thank you very much! This is exactly what I needed.