Creating a data input sheet with excel


So I am attempting to create a dashboard whereby data can be inputted in different categories and then once the data is submitted it is sent to a different sheet, the data that was typed into the cells is removed, and then next time further data is inputted it places the data sent to the other sheet below the previously submitted data?

Most data to be inputted has 1 row and 10 columns. Of which all have to be copied and placed beneath the previous on a separate sheet once a submit macro button is pressed.

Thank you
See more 

1 reply

Registration date
Sunday September 12, 2010
Last seen
November 14, 2019
Thank you
Hi Matt,

Could you let us know which data needs to go where or is just cut/paste A2:J2 (= 1 row and 10 columns) from Sheet1 to Sheet2 first available row?

Best regards,
Respond to TrowaD