Okay, I've got a spreadsheet that has a list of 14 questions on it. These are answered by drop down menus (using validation lists). That's not the important matter.
When they've finished this they click a button and it exports the answers to a database record.
Now what I want to do is to allow them to click one button so that it clears all the answers ready for the next customer. How do I do that?
Would prefer to avoid VBA if I can. I can send the sheet to you if you need to look at it.
When they've finished this they click a button and it exports the answers to a database record.
Now what I want to do is to allow them to click one button so that it clears all the answers ready for the next customer. How do I do that?
Would prefer to avoid VBA if I can. I can send the sheet to you if you need to look at it.