Macro - how can replicate only a number of times...

Hi,

Please see attached workbook. Can you help me fix this macro. I wanted to do the following..
As you can see, at the moment the macro is written so it pasts 10 items from the third tab "Order Details".
Its also picking up items from the order summary, which is also accurate.
So lets say there's only two items instead of ten on the third tab.
How can this macro can be fixed so it only replicates in an instance like that, it only copies company ABC twice, and only 2 items?
Can you please help?

Hi Celeazul,

Check for the null value and exit from the for loop.

Update the statement:

For i = 1 To 10
'Copy Order Details to Transactional Report
'Row Offset to next item

If Sheets("Order Details").Range("B" & NextAmount) = "" Then Exit For


Regards,
lokicl

Remember To Do the Following....

1. Use code tags. Place CODE before the first line of code and CODE after the last line of code.
2. Thank those who have helped you by clicking the Star * below the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.

[SOLVED]
Thank you so lokicl much it worked. You're the best!!!