Forum Discussion
Scheduling
Hi! I'm doing the daily schedule for nurses and cna at the nursing home where i work. How do i program where i can just choose from drop down to choose the name of the nurses or cna instead of typing...
Hello,
Assuming you have all the Names in A1:A50.
To create the dropdown in cell B1 for example
1. Select cell B1
2. Click on Data Validation under Data tab
3. Click on List from the dropdown
4. Click inside Source and reference the values in A1:A50
5. Click OK.
When you check B1,you will see all the list as a dropdown
Assuming you have all the Names in A1:A50.
To create the dropdown in cell B1 for example
1. Select cell B1
2. Click on Data Validation under Data tab
3. Click on List from the dropdown
4. Click inside Source and reference the values in A1:A50
5. Click OK.
When you check B1,you will see all the list as a dropdown
Abiola1 Thank you! The problem is i don't know how to put names on column A.
