Thanks for your reply!
Sorry I was not clear on that. The activecell was pointed to Range("B2") initially, so that it runs down the table from there.
Therefore the offset(,-1) is to point to the corresponding cell in column A.

However, I just tried out the code, but it returned "Qty units of Name / ".
Could you please advise if I missed out anything on that? Thanks!

Picture1.jpg