Userform to fill sales bill details

I am makimg a userform that fills all manual sales bill details into the form. it is working fine all controls are precise.
But i overlooked one fact ,one bill can have upto 20 items with different unit price. i dunno how to incorporate these onto the worksheet under one PO or Invoice number. when i enter the items i want all the items under one PO #, one line item. I dunno how to code it that way only for two column
in the program. It is not working the code. can u pls help?

po # item unit price total value of bill tax
p123 abc 1 10 10%
bbc 3
cbc 2

Originally Posted by vlady

Moderator's Note:

Welcome to the forum Aditi7.

To attach a file as requested by Solus.

Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

hi solus,

I've attached the excel above .pls check n let me know if it can be done.

both actually ... mostly PO number. can it even be done? pls let me know

ok i got everything to work.except one part merging cells, i tried and failed, so was thinking of vertically stacking the values in multiple rows into cell.

can u please help with that?