title: How to copy the last (n)rows of a google sheet to a new sheet
body: <p>I am new to Google Apps and Google sheets and would appreciate a little help. I have a google sheet with some data in a table that is simply a date column and then a few columns of data collected from that date with a new row for each days data. I wish to copy the last 7 days, 30 days,  60 days etc to a new sheets. Essentially copy the last (x)Rows of a table to a new sheet where I can vary (x).</p>
  
  <p>Is there a simply function that I can use on a new sheet to get the desired (x) rows from the table.
  Or do I have to use a script. If so how do I proceed. </p>
  
  <p>Any replies would be greatly appreciated.</p>
  
  <p>Thank you</p>