This question is somewhat similar to question posted on the stakeoverflow community at below link (however, there are few modifications) copy data from one sheet to another in google app script and append a row, one small issue.
In the above link the script copies the data of Copy Sheet to Sheet named Paste and then deletes the data from sheet named Copy. However, the data till row no. 13 is only copied and date till row no. 13 deleted. I want the script with below changes.
In my case, there are three sheets named Data, Copy, Paste. I want an appscript which will run when user changes selection in Cell F3 of sheet named Data. The appscript will perform below task: (1) Delete the entire data of sheet named Data (all rows except row no. 1). (2) Delete only Column B and C of sheet named Copy (all rows except row no. 1). (3) Copy the data of Sheet named Copy into sheet named Paste in Column B and C (should not overwrite the existing data but should keep the existing data and copy the new data.)
For ease of understanding am also sharing the link of sample sheet.
Any help on above will be appreciated.
