title: How would I create a copy of an entire spreadsheet when a specific cell has been edited?
body: <p>The title says it all. When the specific cell A9 is edited I need to create a copy of the entire spreadsheet inside of an <em>Invoice</em> folder. The cell is an invoice number, so when an invoice number hits the sheet I need to create a copy of it so all invoices can be collected at the end of the day and can be printed/manipulated. Any ideas?</p>