Validation on Cell

[NeilB1701]

Hi I have been looking through various posts for an answer to this question and need some help please.

At work we use spread sheets as timesheets. The first column is for a project code and is either entered as 'SC1111' for service calls or '12345-0111'.In both examples the numbers could be anything. But the length is always the same.

Validation seems quite basic is there a way to get Excel to prevent any other input in a range of cells, I know it is tricky as neither possible data entries are similar.

Thank you

Neil

 

[wrightyrx7]

If you have a list of all the codes used, you could use data validation.

Of you could use a VBA to check if the code is either

Two letters followed by 4 numbers = SC1111
OR
5 numbers - 4 numbers = 12345-0111