Looking for a macro (or maybe a function I don't know of) that will reset my counted data when a certain data validation option is selected. Right now my spread sheet will say the sum of an input quantity, the status (either "pending" or "release"), and the WO released (my data validation) which gives the options of yes or no. When the WO Released is selected to say "yes" the status is switched back to pending. The only issue is that when it says "yes" the data (the inputted quantity) doesn't reset. I also want there to be a way so that the next time a quantity is inputted that WO Release goes back to "no".
Bookmarks