What I am trying to do is write a validation routine to check the
values on an Excel worksheet.

For instance, cells A1, A3 and A5 will contain different strings
depaending on the data entered by the user. This is being done via the
Excel data validation tool.

A1 = Leicester
A3 = Leicester
A5 = Coalville

Once the user has completed the form, he/she will click an update
button to copy the revisions to a new worksheet (this I have no problem
with). Before the data is copied however, I want the routine to check
that the contents of the three cells meet the specified criteria, in
this case "Leicester", "Leicester" and "Leicester", the above example
will obviously fail and request that the user make the appropriate
adjustments (again, this I have no problem with).

Any help with the validation would be much appreciated.