I am trying to import data from Sheet 1 to Sheet 2 using Query, but I have a problem. I need somehow to automatically keep the data that I've imported on sheets 2, after it get deleted from Sheet 1. Is it even possible?

  • Welcome to Web Applications. What kind of solution are you looking? What about doing copy - paste special -> paste only values? Have you considered to use Google Apps Script?. If you haven't done yet, please read How to Ask.
    – Rubén
    Jun 10 at 2:52


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.