Hello , i need put in validation data a formula or vba a code for check the next :
In sheet “Codes” put the code for example in column C “asdf” and in the column J put 2.
In the second sheet “Pool” put the next below:
<tbody>
</tbody>
I need check for the same code if in column J (“Codes”) is 2 or 3 , the cell (Number) in sheet ”Pool” must have a value greater than zero and less than 101. Otherwise if colunn J in sheet “Codes” have another value , the cell (Number) have the value 0.
Thank you
In sheet “Codes” put the code for example in column C “asdf” and in the column J put 2.
In the second sheet “Pool” put the next below:
| Codes | Number |
| Asdf | 100 |
<tbody>
</tbody>
I need check for the same code if in column J (“Codes”) is 2 or 3 , the cell (Number) in sheet ”Pool” must have a value greater than zero and less than 101. Otherwise if colunn J in sheet “Codes” have another value , the cell (Number) have the value 0.
Thank you
