Data validation

[Amith]

hi

I am developing this calculator at work. It has our bill rates on another sheet, listed by business units and the various roles. i.e Businss Unit X, Director (Grade 1) £x per hour... etc...

Now some do not have rates.

On the main file, I wanted to add a message box when a person is compiling their budget, that a certain director/manager - role does not have a rate....

How can I do this??

Thanks

Amith

[JR@SGC]

You will need to use the validation setting under the data drop down menu.

hope it helps