title: How to record historical data in Google Sheets using Apps Script
body: <p>I am seeking help with an automation process in Google Sheets. The goal is to automatically record data when a user edits a cell within the range H2:H22. Ideally, the program will copy the cell that was changed and also copy a cell from column I (in the same row) to a new sheet tab, while also adding the date at the time of copy.</p>
  <p>So, for example, if user edits H2 - the program will copy H2 and I2 from sheet1, and paste into sheet2. Sheet2 is organized by date, column I, then column H for pasting order. Thanks for the help!</p>