Excel form to submit and collect the data then reuse the form

[braidp]

Hi guys,

I was wondering if you could help - I have an observation form that has input boxes for Y/N in them that once completed I would love to be able to hit submit and the data is moved to a master file then clears the data from the form to use again for the next submission.

Therefore over time as more and more observations were completed it would build all the data submitted into one file with the 'observation file' blank

Anyone know how to do/solve this?


Many thanks

 

[Yongle]

Is each "observation" a row of data?
Is there a record identifier and date in each row?
Are the input boxes cells or checkboxes?
How many columns \ input boxes are there?
Is there only one sheet in Master workbook? and one sheet in observation workbook?