Filling empty cells with the right data from another sheet

Good morning!

I got my invoice and my journal. Once I finish my invoices I send all to the journal, but I am having a little problem.... Here is my code

Please Login or Register  to view this content.

Sometimes with the invoice not all the rows that I am copying have items. Therefore, when it is pasted into the journal, I may only have 2 lines, but the invoice number ends up only in the first blank row. I have to change it manually.
Is there a way that I could do it automatically. In other words, everytime I paste however many lines, I also want to paste the same amount of invoice numbers.

Thanks for the help!

1) The invoice # is being pasted into column A, yes?
2) So, add a variable to determine what the current lastrow of datais in the Journal (based on column F since you just pasted data there) , then copy the invoice number into the whole range until it fills the empty rows.

Please Login or Register  to view this content.