Create Google App Script to Move (CUT) Row from One Sheet to Another in Same Workbook
£10-20 GBP
Completed
Posted almost 2 years ago
£10-20 GBP
Paid on delivery
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,
Hi greetings from Tushar!!
I am interested in taking up your *Google Sheets* project of moving your archive leads data from your active sheet to Archive Leads sheet .
I have hands on experience of working with google app script, google sheet, APIs and google forms and have done few projects previously using google app scripts and google sheet functions and so I believe I can surely help you as well. Let's connect over chat to discuss further on this.
Looking forward to hear from you.
Thank you.
Hi, I have seen this, Albion website project and I can do this right now. I am an expert in PHP, Website Design, Graphic Design, WordPress and HTML skills and SPEED CODING WINNER. I am sure that I can do your task efficiently in less timeline and budget. Thanks
***Google Sheets***
I understood the requirement and i can give you the appscript for the functionality. I have good experience in google sheets app script. Thanks.