I run a spreadsheet at work (the details I will not bore you with!) and I would like to make some improvements to it. The sheet is a shared file which many users enter data to and I then collate this data and process it, one of the big problems I have is when a manager enters the same data twice which causes an error when processing.
What would I like to be able to do?
When data is entered I would like the sheet to look across all worksheets in the file and validate if this has already been entered (the data is in the form of a unique 7 digit numeric) if it already appears it should return an error message to tell the user that the number already exists elsewhere. Is this possible and of course if so can anyone help with the how?
Many thanks
A new user!