I am home with a sick child today so i just googled and found this article on Data Validation which might assist. http://office.microsoft.com/en-au/ex...600.aspx#BM4_2


Take a look at the info on "Restrict data entry to a whole number within limits".

If you are still stuck I can try to take a closer look at this over the weekend and possibly put something together for you.

Hi,

Sorry to hear about your child, hope they get better.. I have tried data validation and still cannot seem to get it working, I dont know if I am missing something out or what but it just will not work Please go through the excel file I attached and do it for me whenever you are free, will be much appreciated.