title: Shift Cell Range in Google Sheets
body: <p>I'm trying to take a range of cells and shift them all to the right by one cell.  I'd like this to occur once per weekly automatically.  I'm aware in the Script editor I can create a trigger for it to schedule weekly, but I'm not sure how to code it.</p>
  
  <p>If someone can help provide a code that allows me to indicate which SHEET and CELL RANGE to shift to the right by one cell, I would appreciate it.</p>
  
  <p>Basically, what I'm trying to accomplish is tracking data for a number of weeks.  Each week the sheet will be updated, and I would like the older data to shift right one, basically indicating that the data has gotten a week older.</p>
  
  <p>In addition, I'm only trying to keep data for like 6 weeks, so the data isn't ongoing forever.</p>
  
  <p>A bit of an example: Column A = current week (updated manually).
  Columns B-F = previous weeks (1-5 weeks ago).</p>
  
  <p>Once a week, the data in columns A-E should be shifted right 1 to preserve the data.  After the shift, data is manually updated in Column A to represent the current week.  This would then result in showing data for the current week and 5 additional weeks... totaling 6 weeks of data.</p>
  
  <p>I'd be interested if there is a way to just shift columns while excluding the header row, instead of a range, if possible.</p>