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

braidp

New Member
Joined
Dec 27, 2018
Messages
35
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
 

Some videos you may like

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

Yongle

Well-known Member
Joined
Mar 11, 2015
Messages
6,743
Office Version
  1. 365
Platform
  1. Windows
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?
 

Watch MrExcel Video

Forum statistics

Threads
1,108,954
Messages
5,525,880
Members
409,669
Latest member
JDCupps

This Week's Hot Topics

Top