I am looking to create a data validation formula. I have a list of names in column C from 3-20.
In A2 I want to put in the name at the top of list (C3) and when I hit enter that name will rotate to the bottom (C20) and the next name moves up. I have the code on the sheet but I can not figure out what to use it works once and when I put the next name in it does nothing.
I know I need a formula so it works with the names in column C I just don’t know how.
Can anyone help?
Thank you
Maria
In A2 I want to put in the name at the top of list (C3) and when I hit enter that name will rotate to the bottom (C20) and the next name moves up. I have the code on the sheet but I can not figure out what to use it works once and when I put the next name in it does nothing.
I know I need a formula so it works with the names in column C I just don’t know how.
Can anyone help?
Thank you
Maria