Google Script for sheet to write data from one sheet to another and delete from original sheet
Budget: $30 – $250 USD
We will have one form that receives data from our website.
This data will need to be sorted based on criteria in one column and pushed to 1 of 6 different sheets depending on that criteria.
Once that data has been written in the last row of the target spreadsheet, it needs to be deleted from the original sheet.
Example -
John Doe selects Location #4 in a form.
This feeds the worksheet titled MCU
John Doe's data gets pushed to a separate sheet for Location #4 and deleted from MCU.
This cannot be an importrange or query based formula, we need a script that actually moves the static data and deletes it after it's been moved to the other sheet (not just a separate tab of the same sheet)
Simple!
This data will need to be sorted based on criteria in one column and pushed to 1 of 6 different sheets depending on that criteria.
Once that data has been written in the last row of the target spreadsheet, it needs to be deleted from the original sheet.
Example -
John Doe selects Location #4 in a form.
This feeds the worksheet titled MCU
John Doe's data gets pushed to a separate sheet for Location #4 and deleted from MCU.
This cannot be an importrange or query based formula, we need a script that actually moves the static data and deletes it after it's been moved to the other sheet (not just a separate tab of the same sheet)
Simple!