I need to enter a RO# in a cell on Sheet1 and then check to see if that RO# is already in a list on Sheet2. If it is, return message that it's a duplicate and to try again. If not, then add it to the list and save the file.
I can find bits and pieces of the code I'm needing but don't understand it enough to tweak and put together as I need it.
Thanks for any help.