Copy Paste Formula adding extra rows

Hi there
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

Administrative Note:

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not told us about this. You are required to do so.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important: https://excelguru.ca/a-message-to-forum-cross-posters/

(Note: this requirement is not optional. As you are new here, I shall do it for you this time: https://www.mrexcel.com/board/thread...-rows.1219918/)

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, you may not be aware that you can thank those who have helped you by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.

I am trying to create a Macro which will copy the rows of my first "invoice" - and then continue to paste those rows beneath each other "x" number of times? The number
of times could either be a message box with an input I enter, or it could count the number of rows in the sheet !jobs - to give the number of times it should paste if possible?

Rows to copy (=A1:AB22)
paste in: (=A23:AB44)
and then paste again in (=A45:AB66)
and then paste again in (=A67:AB88)

I have found this but am struggling to get it working:

Please Login or Register  to view this content.