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
Did you like this article? Share it with your favourite social network.