I have a macro set up which takes the values of various cells on 1 sheet, then puts them in to (the first empty) single row (so it's easier to look through entries) on another sheet when the macro runs.
Is there any way to prevent the exact same thing being entered twice?
I have a yes no box asking to confirm if you want to enter the details and create a new row on the list sheet just now but you could just keep entering the same thing multiple times.
Any way to prevent that?
Is there any way to prevent the exact same thing being entered twice?
I have a yes no box asking to confirm if you want to enter the details and create a new row on the list sheet just now but you could just keep entering the same thing multiple times.
Any way to prevent that?