Kurt Smart
Member
Hi everyone,
I have little experience with VBA, could anyone come up with a solution or guide me on the path to achieve the below...
Enter number in H2...
Check if it exists in 'Completed' or on 'In Progress' tabs...
If it does input zeros in I2, J2, K2 & L2...
If it doesn't exist then only allow inputs higher than zero in same cells above.
I'm trying to stop people from inputting say in I2 a number 45 then in J2 20 and then zeros in the other two, I want data higher than zero in all 4 of those cells, only if that number in H2 doesn't already exist (duplicate).
Thank you for any help or/and solutions
I have little experience with VBA, could anyone come up with a solution or guide me on the path to achieve the below...
Enter number in H2...
Check if it exists in 'Completed' or on 'In Progress' tabs...
If it does input zeros in I2, J2, K2 & L2...
If it doesn't exist then only allow inputs higher than zero in same cells above.
I'm trying to stop people from inputting say in I2 a number 45 then in J2 20 and then zeros in the other two, I want data higher than zero in all 4 of those cells, only if that number in H2 doesn't already exist (duplicate).
Thank you for any help or/and solutions