Template Employee absence schedule

%3CLINGO-SUB%20id%3D%22lingo-sub-1462844%22%20slang%3D%22en-US%22%3ETemplate%20Employee%20absence%20schedule%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1462844%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20using%20the%20template%20Employee%20absence%20schedule%20but%20I%20can't%20add%20more%20than%205%20employees.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20can%20add%20them%20in%20the%20sheet%20'names'%20but%20i%20can't%20select%20them%20in%20the%20months...%20Am%20I%20missing%20something%3F%26nbsp%3B%3C%2FP%3E%3CP%3EI%20can%20only%20select%20the%20first%205%20names...%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EI%20am%20new%20to%20this%20so%20I%20appreciate%20all%20insights!%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1462844%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1463196%22%20slang%3D%22en-US%22%3ERe%3A%20Template%20Employee%20absence%20schedule%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1463196%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%2F699367%22%20target%3D%22_blank%22%3E%40LIeselotte_R131%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThey%20have%20used%20data%20validation%20in%20creating%20the%20items%20you%20can%20select%20in%20the%20months%20tabs.%20In%20order%20to%20select%20any%20new%20employee%20added%20on%20the%20names%20tab%2C%20you%20have%20to%20update%20the%20source%20on%20the%20data%20validation%20to%20pick%20all%20the%20new%20cells%20added.%20See%20below%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22wumolad_0-1592223385484.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F198821i38D0816BDBBD3CCC%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22wumolad_0-1592223385484.png%22%20alt%3D%22wumolad_0-1592223385484.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3ETo%20do%20this%2C%20go%20to%20Data%2C%20select%20data%20validation%20under%20Data%20tools%20group%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20attached%20an%20updated%20workbook%20for%20you.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDo%20let%20me%20know%20if%20this%20works%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi, 

 

I'm using the template Employee absence schedule but I can't add more than 5 employees. 

I can add them in the sheet 'names' but i can't select them in the months... Am I missing something? 

I can only select the first 5 names... 

 

I am new to this so I appreciate all insights! 

2 Replies

Hi @LIeselotte_R131 

 

They have used data validation in creating the items you can select in the months tabs. In order to select any new employee added on the names tab, you have to update the source on the data validation to pick all the new cells added. See below:

 

wumolad_0-1592223385484.png

To do this, go to Data, select data validation under Data tools group

 

I have attached an updated workbook for you.

 

Do let me know if this works,

 

Cheers

This was very helpful @wumolad & @LIeselotte_R131 

How does one enable the drop down selection in B17 if you have more than 10 Employees?
When tabbing through to the end of template it creates a new row but doesn't seem to enable the drop down employee list. Therefore, not related to Data Validation function.