Tweet
I have a sheet "invoice template" which contains 6 rows per 'invoice'. Each invoice pulls the reference and the container number from the second sheet ("jobs")
This works in the first 6 rows reference is =jobs!A2,and container is =jobs!B2
However when I copy those 6 rows in 'invoicetemplate" to create the next invoice underneath it (from row7) the formula pastes the reference number as =jobs!A8 instead of =jobs!A3, and container number pastes as =jobs!B8 instead of =jobs!B3
basically the formula is adding the 6 rows each time it is pasted - which it should not do as the items in the job sheet are underneath each other with no open rows.
invoice.xlsx
This works in the first 6 rows reference is =jobs!A2,and container is =jobs!B2
However when I copy those 6 rows in 'invoicetemplate" to create the next invoice underneath it (from row7) the formula pastes the reference number as =jobs!A8 instead of =jobs!A3, and container number pastes as =jobs!B8 instead of =jobs!B3
basically the formula is adding the 6 rows each time it is pasted - which it should not do as the items in the job sheet are underneath each other with no open rows.
invoice.xlsx