So I've put hours and hours into this with no avail. Here's my situation...I have on "Sheet 1" a list of materials which could potentially be used during a job. I have it set up so that if I populate the quantity column (i.e. I used 1 or 2 during the job) it will give a sub-total and grand total at the bottom of the sheet.
I have an invoice template on "Sheet 2". My idea is...if on sheet 1 I populate the quantity column (obviously I used the item and will be charging the customer for it). I want the description (in column 1), the quantity (in column 2), and the price (in column 3) to be copied over to my invoice sheet if AND ONLY IF I populated the quantity column on sheet 1.