I have created a form for work.
I have different sections for users to fill out. I have a submit button at the top which validates data in specific cells and then if they are complete, it allows and email to pop up with the file attached, if not, then it comes up with an error to complete all fields.
The user has the option to click a button to unhide additional rows for another quote and they can then fill out that section. I am trying to get the submit button to then verify all of the cells in that section are complete before it sends... and so on for 9 additional quotes.
How can i get this to happen? I have tried doing an additional VALIDATEDATA macro but not sure how to get it into this formula to verify.
I do have a cell that is calculating how many of these "quotes are filled out"
is there a way for the button to take that number and then determine how many cells should be filled out?
Forms, Formulas and Dropdowns. Difficult
Reply With Quote