Create Google App Script to Move (CUT) Row from One Sheet to Another in Same Workbook
Budget: £10 – £20 GBP
I'm currently using mail parser to populate data by creating a new row in Google Sheets online (Sheet Name 'Active Leads' Columns A:S)
In column D I mark the row with Data Validation (New, Active or Archive). However, I want to use this sheet only for new and active data only.
When I mark row as ‘Archive’ – I would like to cut / move this row to another sheet (Archive Leads) with the same table. This means I can actively work on the data that is new and active in Active Leads sheet, and use Archive Leads for storage only.
I understand that I can achieve this task through cut / paste. However, I need to remove the manual process due to a large volume of incoming data.
I would like to hire you to help create google app script to automatically move row from Active sheet to Archive sheet, without leaving blank rows in Active sheet. This could be On Open sheet. (i.e. If I close the sheet and reopen the automation script happens).
Please note, I cannot share or provide access to Google Drive or share document due to sensitive data and other reasons. However, I am equipped and able to install google app script with instructions.
Please Comment with ***Google Sheets*** In your bid for this project so that I know you’re fully genuine and you have fully read these instructions. I am happy to discuss more over chat.
Thanks,
In column D I mark the row with Data Validation (New, Active or Archive). However, I want to use this sheet only for new and active data only.
When I mark row as ‘Archive’ – I would like to cut / move this row to another sheet (Archive Leads) with the same table. This means I can actively work on the data that is new and active in Active Leads sheet, and use Archive Leads for storage only.
I understand that I can achieve this task through cut / paste. However, I need to remove the manual process due to a large volume of incoming data.
I would like to hire you to help create google app script to automatically move row from Active sheet to Archive sheet, without leaving blank rows in Active sheet. This could be On Open sheet. (i.e. If I close the sheet and reopen the automation script happens).
Please note, I cannot share or provide access to Google Drive or share document due to sensitive data and other reasons. However, I am equipped and able to install google app script with instructions.
Please Comment with ***Google Sheets*** In your bid for this project so that I know you’re fully genuine and you have fully read these instructions. I am happy to discuss more over chat.
Thanks,