VBA Data Validation

Hi,

I have inserted data validation into the attached example spreadsheet ensuring only one value can appear in cells in columns C/D to give the user one option of recording a pay increase in terms of £ or %. If the user attempts to complete both columns an error message prevents them from doing so.

I need to add an additional validation to prevent both C/D columns being completed if the employee (identified by the unique number in column A) is present on the 'Promotions' worksheet. I think I can amend my data validation using the OR/ CountIf function, but ideally would like to include a different error message if the employee appears on the 'Promotions' sheet - is this something that can be done via VBA?

Here is a summary of how the function should work.

- Employee 2 does not appear on promotions sheet. They can have an increase recorded on the 'Pay' worksheet in either the C or D columns, but not both.
- Employee 1 appears on the promotions sheet. They cannot have an increase in either the C or D columns and if the user attempts to insert one an error message appears telling them this is because they appear on the 'Promotions' worksheet.

Thanks,

cd254

This is perfect, thanks so much for your help!