Creating a data input sheet with excel

Closed
excelmatt23 - Updated on Jul 19, 2019 at 08:31 AM
TrowaD Posts 2913 Registration date Sunday September 12, 2010 Status Moderator Last seen November 21, 2022 - Aug 6, 2019 at 12:00 PM
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

TrowaD Posts 2913 Registration date Sunday September 12, 2010 Status Moderator Last seen November 21, 2022 541
Aug 6, 2019 at 12:00 PM
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
0