NOvice needs code to combine function and sub

[bmills1919]

I'm brand new at using VBA. I searched for a similar problem here an in other forums but can't seem to find the exact issue.

I have a workbook with two sheets. One contains inventory info ( product number, description, price and number sold). Sheet two contains product number, description, and profit distribution between two parties. I want an entry in the number sold column on sheet one to trigger a transfer of the product information from that row to the next open row in sheet 2, and at the same time calculate a 70%-30% split of the profit (price times number sold) into 2 columns on sheet two.

Could someone please map this out for me?

Thanks.