VBA to find first available row after finding a string in the worksheet

Good Day,
I have an excel database that has records that have multiple rows. I want to search for the part number of the record using a userform and find the first available row to append data, from the rests of the userform, to the record. I have been able to find the correct row of the part number but when I try to search for the first blank row after that reference it does not work. I've attached a portion of the code below. Any ideas?

Please Login or Register  to view this content.

Hi,
Could you please explain elaborately what is your requirement?

Otherwise, you can use below code to get the last available blank row.

Please Login or Register  to view this content.

You can chang the Column as per your requirement. (here column is "A").

Regards
taps

I have a excel database for inventory items. Each item has multiple rows beneath the part description and part number for multiple purchase orders and quantities, multiple receipts and quantities and multiple shipping notices and quantites. I need to keep a running total of on hand inventory. What I want the userform to do is search for the part and then find the first available row in the rows beneath the correct part and place the purchase order and quantitiy that is also entered in the userform. I would have three userforms for each of the functions (purchase orders, receipts, and shipping notices). Does this help clarify what I want?