Selecting next available row in target column

Hi,

I am trying to get this right. Any help will be appreciated. I have a sheet and a form to input data. After getting the Lot ID from user the code checks the lot id., insert a row and move one col. right and insert data.
What I want to do is move one col right then check if there is no data insert a row and put data in. If there is already data (in col B)then it should insert a row at the end of that particular lot extension (in col. B). Please look into the sheet it would be easier to understand what I am trying to describe.
Thank you for your help
Jaz

Hi Guys,
I hope someone can help me on this.
thanksJaz

Hi Guys,
I hope someone can help me.
thanks

One more time, can someone help me.
Hope to hear from the busy contributors.
Thanks
Jaz