I'm working on a reading tracker and have the dates of the year running Z->A in a range on Google Sheets (today is the first row, and Jan 1 is the last row). I have columns with the date, the book I am reading, and the number of pages I read that day.

How do I move down the entire range of values down by a row, and add a new row at the top (the new 'today' date) automatically every day?

  • Hi, take a look at link
    – Daniele
    Jul 22 at 20:42
  • Hi, welcome to WebApps. You have no formulas so why not just put the cursor on the "Date" header, select "Insert", "Rows", Insert one row below". Type in the date and away you go. Possibly you could create a macro to insert the new row.
    – Tedinoz
    Jul 23 at 0:31
  • @Daniele, am I missing something? The referenced link doesn't seem relevant to this question. It is a script to move an input row and "append" it plus possibly use a form to create the new input. In this question, the data is, I think, already in the correct order and its just a case of inserting a new row at the top of the sheet to accept the next day's data.
    – Tedinoz
    Jul 23 at 0:38
  • @Tedinoz Here the keyword would appear to be "automatically" and that script could be a starting point, perhaps set with a timer
    – Daniele
    Jul 23 at 8:28
  • 1
    @Daniele It seems like these kind of questions (Member for 2 days-way too vague- showing no effort as well no interest on replying on comments) are just students' exams/projects questions. One will effortlessly get some credit, learn nothing (other than copy-paste) and overall waste everyone's time (including theirs). Consequently your efforts will do no-one no good whatsoever :( Jul 23 at 18:54


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.