The above link is a picture of the Google Docs spreadsheet that I am working on. Basically it is a sale ticket for a small appliance parts store.
I need to be able to select a range of rows and have them moved to another sheet.
If there is ever an "X" in column H, I need the script to copy the sale ticket and move it to another sheet. How do can I tell the script how big of a range to copy? The number of rows will vary depending on how many items are on the sale ticket. Most likely anywhere between 11-15 rows.
Edit, one idea is to have have it so when it detects an "x" in column H, it counts down the column until it finds the words "Amount Due". I just don't know how to implement this.