Home

Populated template

%3CLINGO-SUB%20id%3D%22lingo-sub-353520%22%20slang%3D%22en-US%22%3EPopulated%20template%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-353520%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20am%20using%20the%20employee%20absence%20schedule%20template%20and%20breaking%20the%20calendar%20into%20quarters%20for%20the%20year%2C%20with%203%20months%20on%20each%20sheet.%20I%20would%20like%20to%20be%20able%20to%20track%20several%20years%20in%20the%20same%20worksheet-%20is%20there%20anyway%20to%20be%20able%20to%20do%20this%3F%20The%20template%20populates%20the%20entire%20year%20which%20is%20great%2C%20I%20just%20can%20not%20figure%20out%20how%20to%20make%20it%20populate%20for%20multiple%20years%20if%20this%20makes%20sense%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20new%20to%20this%20so%20I%20appreciate%20all%20insights.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-353520%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-355405%22%20slang%3D%22en-US%22%3ERe%3A%20Populated%20template%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-355405%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%2C%20Wyn.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20will%20try%20this.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%2C%3C%2FP%3E%3CP%3EPalin%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-355180%22%20slang%3D%22en-US%22%3ERe%3A%20Populated%20template%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-355180%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F287088%22%20target%3D%22_blank%22%3E%40Palin145%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt%20could%20be%20done%20but%20would%20be%20quite%20a%20bit%20of%20work%20and%20the%20ability%20to%20report%20a%20summary%20for%20the%20year%20etc%20would%20be%20quite%20tricky%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EMy%20approach%20would%20be%20to%20use%20something%20simple%20like%20the%20attached%20file%20with%20a%20simple%20table%20where%20you%20enter%20the%20names%20and%20dates%20and%20then%20a%20Pivot%20Table%20report%20which%20summarises%20the%20results%20by%20Year%20Quarter%20and%20Month.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-353968%22%20slang%3D%22en-US%22%3ERe%3A%20Populated%20template%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-353968%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Wyn%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20template%20is%20a%20monthly%20calendar%20that%20auto%20populates%20the%20years%20dates%2C%20in%20each%20month%2C%20once%20selected.%20Say%20I%20plugged%20in%202025%20as%20the%20year%2C%20the%20dates%20populate%20for%20each%20month%20which%20is%20a%20great%20feature.%20However%2C%20the%20template%20is%20designed%20to%20populate%20for%20one%20calendar%20year.%20I%20am%20attempting%20to%20add%20several%20calendar%20years%20to%20one%20workbook%2C%20broken%20into%20quarters%20for%20each%20year-%20if%20that%20makes%20sense.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20any%20assistance%20or%20guidance%20you%20may%20offer%20in%20advance.%3C%2FP%3E%3CP%3EPalin%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-353651%22%20slang%3D%22en-US%22%3ERe%3A%20Populated%20template%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-353651%22%20slang%3D%22en-US%22%3EHi%20%3CBR%20%2F%3E%3CBR%20%2F%3EAre%20you%20able%20to%20post%20an%20example%20workbook%20and%20explain%20a%20bit%20more%20about%20how%20the%20data%20is%20set%20up%20and%20what%20you%20want%20to%20see%20when%20you%20say%20%22track%22%3CBR%20%2F%3E%3CBR%20%2F%3EThanks%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
Palin145
New Contributor

Hi, I am using the employee absence schedule template and breaking the calendar into quarters for the year, with 3 months on each sheet. I would like to be able to track several years in the same worksheet- is there anyway to be able to do this? The template populates the entire year which is great, I just can not figure out how to make it populate for multiple years if this makes sense?

 

I am new to this so I appreciate all insights.

 

Best!

4 Replies
Hi

Are you able to post an example workbook and explain a bit more about how the data is set up and what you want to see when you say "track"

Thanks

Hi Wyn,

 

The template is a monthly calendar that auto populates the years dates, in each month, once selected. Say I plugged in 2025 as the year, the dates populate for each month which is a great feature. However, the template is designed to populate for one calendar year. I am attempting to add several calendar years to one workbook, broken into quarters for each year- if that makes sense.

 

Thank you for any assistance or guidance you may offer in advance.

Palin

Hi @Palin145 

 

It could be done but would be quite a bit of work and the ability to report a summary for the year etc would be quite tricky

 

My approach would be to use something simple like the attached file with a simple table where you enter the names and dates and then a Pivot Table report which summarises the results by Year Quarter and Month.

 

 

Thank you, Wyn.

 

I will try this.

 

Best,

Palin

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Edge insider Dev bypasses IE mode website list
HotCakeX in Enterprise on
4 Replies