Creating a data input sheet with excel [Closed]

Report
-
Posts
2693
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 18, 2021
-
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

1 reply

Posts
2693
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 18, 2021
454
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!