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 their names? Thank you in advance. Here's the example of the schedule that I'm doing:
5 Replies
If you are open to a VBA approach to this, find the attached with the VBA code implemented along with the instructions how to use this.
The file contains a sheet called Nurses & CNA where you can list all the names you want to insert on Sheet1.
Subodh_Tiwari_sktneer Thank you! The problem is i don't know how to put names on column A.
First off, did you test the file I uploaded? Did it work as I described?
The name which you want to select from the dropdown list must be stored somewhere in the file either on Sheet1 itself or on another sheet because the dropdown list needs a source data to fill the dropdown which you can expand and select the desired name from the list. You should store all the names in column A on Nurses & CNA sheet replacing the dummy names I put there.
- 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 dropdownAbiola1 Thank you! The problem is i don't know how to put names on column A.
