Forum Discussion

Lainey3's avatar
Lainey3
Copper Contributor
Aug 02, 2019

Employee Absence Schedule

I can't seem to get all my employees to show up under the drop down menu after I have added them to the list.  They show up on the Employee Name tab but when I go to add them to the month that I am w...
excel
PReagan's avatar
PReagan
Bronze Contributor
Aug 02, 2019

Lainey3,

 

It looks like the problem was that the source of your data validation list was ='Employee Names'!$B$4:$B$8 when instead it should have been ='Employee Names'!$B$4:$B$12. I fixed this issue but only for the August tab. You may copy the cells from the August tab to the other monthly tabs if you would like to have the same list in each tab.

 

Hope this helps!
PReagan

Lainey3's avatar
Lainey3
Copper Contributor
Aug 02, 2019

PReagan 

How do I copy the cells?  Thanks so much!

 

Lainey

  • PReagan's avatar
    PReagan
    Bronze Contributor
    Aug 02, 2019

    Lainey3,

     

    Select the cell you would like to copy and hold Ctrl+C. Then select the cell you would like to paste it in and hold Ctrl+P.

     

    If this helped please mark my response as the Best Response!

     

    Thanks!
    PReagan