Hello All,
I would like to be able to automate the Entry of (Spot Checker) Names into the Cells E26:E36,E46:E57,E62:E63,J26:J36,J38:J40,J46:J49 of my form.
The form on the "REPORT" Sheet Starting in Cell Q6. The list from an advanced filter (so it is not static).
The idea is to use the Khaki list of name in Q6 and loop thru the names adding one to each cell. The catch is I wat the user to select the name from that list start from entering that name into cell E26. So if I where to choose the last name in the list it would go to the top of the list and run through filling the 39 cells with the Names until filled.
Please see the attached file, all data is completely false.
I don't know how to approach the solution and want to Thank your for looking at this project.
V/r,
Jim
Bookmarks