Here is my issue. In Cell G29 G30 G31 G32 G33 I have a list of values in a hidden sheet that they can key in a specific value from the list (this works). It uses data validation to confirm the value entered is in the list.
What I need to do now is add a second validation that checks to see if there is a value <> 0 in H29 H30 H31 H32 H33. If there is a value in H then check to make sure there is something keyed into G.
It doesn't matter how this is accomplished as long as it works.
Any thoughts? Is VB script in the sheet the best route? Is there a simple way I am not thinking about? Keeping in mind that I have no coding experience.