Formula or Macro check data

[NerakSeven]

Hello , i need put in validation data a formula or vba a code for check the next :

In the sheet (“Codes”) put the code for example in column A “asdf” and in the column B put the 125

In the second sheet (“Length”) put next values below:

·

Codes	Length
asdf	100
asdf	25
asdf	25

<tbody>
</tbody>

I need check that values in sheet “Length” is greater than 0 and less than or equal to the total length for that code defined in sheet “Codes”

thank you

 

[Fluff]

How about
=AND(SUMIF(Length!A:A,A2,Length!B:B)>0,SUMIF(Length!A:A,A2,Length!B:B)<=B2)