Hi there -
I have drop down boxes containing names in D24:G24. All the drop down names are the same in each cell. Based on what name the user selects I would like to be able to check a range D1:G1 to see if the name exists in this range. If it does I would like a message box to appear "Resource on vacation please select another name".
Then have the drop down box clear the name out.
Can you any direct me.
Thank you!
Lorraine
Bookmarks