Menu
Ask a question Report

Creating a data input sheet with excel

-
Excel Ask a question Report
Hi,

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

Report Respond to TrowaD
Posts
2519
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 3, 2019
 361
0
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,
Trowa
Respond to TrowaD
Reply Ask a question