Forum Discussion
Scheduling
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.
