Move Multiple Rows of Data in Google Sheets - Apps Script Tutorial

Поделиться
HTML-код
  • Опубликовано: 8 ноя 2024

Комментарии • 13

  • @christophermiglino2869
    @christophermiglino2869 Месяц назад

    Thanks for making the code available. Writing non-linearly in a linear environment is confusing without the final product at hand. 🤓

  • @THOLOGHANZI
    @THOLOGHANZI Месяц назад

    Thank you so much for this helpfull video. Im learning with every video.
    Just a question: How to I prevent a line from being moved if the tab indicator is blank. I want it to stay on the first page and not be deleted.

  • @rizalfanani9512
    @rizalfanani9512 Год назад +1

    Hey nice video and it actually what i looking for, only maybe because i dont understand of the script coding i dont really know what is happening 😂 but i will try this code later. You are a life saver 👍

  • @fernandogrejo
    @fernandogrejo Год назад

    Thanks Ninja!! This is very helpful

  • @rafalvarezsevilla
    @rafalvarezsevilla Год назад

    Hey Ninja, nice video, though i admittedly didn't understand too much =D do you maybe know how to create a function, that kind of locks cells to each other? i get market data from a GOOGLEFINANCE function, and the data obviously moves every day. i manually enter values in the same row every day, but as the days pass, and the recent prices moves down, i would like my manually entered data to move down as well, though i don't seem to find a way to do this :(

  • @angeo10
    @angeo10 Год назад

    I discovered the channel recently and I'm watching the old videos, can you share the code for this video?😃

    • @SheetsNinja
      @SheetsNinja  Год назад +1

      There is a link to copy the Google Sheet and script in the video description. Thanks for watching!

  • @dnaml168
    @dnaml168 Год назад

    Hi if I just want copy not moving and specific some rows not all how can I do

    • @SheetsNinja
      @SheetsNinja  Год назад +1

      So if you want to copy, not move, all you need to do is delete the row in the code:
      sheet.deleteRow(row);
      If you're looking to add more complex conditions for moving rows, check out this video: ruclips.net/video/KekdeXn8P5Y/видео.html

    • @dnaml168
      @dnaml168 Год назад

      Lovely thank@@SheetsNinja