I was wondering if someone could help with this scenario:
On Google Sheets, I am looking to take data from Sheet 2 and place it in Sheet 1 (Master list), so the data in sheet 2 is temporary and has 5 cells to manually enter data, I want to create a button that submits this data from sheet 1 to sheet 2 and at the same time enters a new row in sheet 2 and clears the data entered in sheet 1.
thanks