Hello novice here, I'm hoping I can get some advice or solution to a problem. I have attached an example spread sheet to better explain. Example.xlsm

Consignment numbers are passed via clipboard in the following format: 0001234567891011;0001393925839291;0001288294928294. It can be 3 to 50 groups of digits each with a ; separator.

I want to be able to click the 'Add' button at the given time slot on sheet1 and paste the numbers into the user form popup top text box . When they are pasted there, the numbers are then sorted in the lower text box to:

0001234567891011
0001393925839291
0001288294928294

With them sorted, when the user form 'Add' button is clicked it will write those numbers into the corresponding time slot cells in Sheet1. What is the best way to accomplish this?

Your help is much appreciated.