VBA To populate listbox with duplicate item by increasing the item quantity

Hi all

I have attached my sample file. I have re-posted this "month old" post as there have been no results. I have reached a stumble block and have no idea how to proceed further. This is the last part of a 3 month project.

I have managed to allow my code to move items from one listbox to another....The listboxes gets populated from Sheets 1 & 2.
What I want to achieve when I press the Process command button is the following:

1. The ListBox selection highlighted which is moved to the other side, must be found in the corresponding sheet for that listbox and moved to the other sheet as per with the Listbox move.
2. The ListBox selection highlighted must be found in Sheets("Temp") and the transaction number in column B must be changed to the transaction no of the Sheet it went to.

My file works as follows:

On opening, UserForm1.Shows
Click [open table] Click [David Table1]
Table 1 will now be populated in listbox1
Click [split bill]
Table1 will now be populated in Listbox2
Click [To open Table to split]
Click [David Table2]
Table 2 will now be populated in ListBox3

You will notice the two individual transaction no's above each listbox i.e 20160929322 & 20160929323
Highlight Banana Shake in ListBox2 and click[>] to move it to ListBox3
Now the magic needs to happen.
1.ListBox3's already existing 1 Banana Shake must now be increased to 2.

When I click [Process]
2. The Banana Shake info must be deleted from Sheets("1") and copied to Sheets("2"), however, it already exists, so the item must just be increased by 1 in other words Banana Shake Qty must become 2

3. The Banana Shake for this Table's transaction no i.e. 20160913323 must be found on Sheets("temp"), be increased to 2 and then Banana Shake from transaction 20160929322 must be deleted.

I sincerely hope someone can assist. Thank you in advance.

So only table 1 and 2 can splt the bill ?


Cheers
Leo

Hi Leo

Thanks for your response. No...any Table needs the capability of a Bill Split and I forgot to mention that the item could not necessary be a duplication. If it is a different item, then it should just process as per normal.

Is anyone able to assist with my problem....

not ready yet
this is 1 of the possibilities


Cheers
Leo

Hi Leo

Wow, some serious code....I like what I see. Going to spend some time and analyze to see what you are doing.
Thanx for the effort you are putting in this.

Leo

You are the man....I just incorporated the first part of the code into my POS System and it works like a bomb.....
Now just to have code to make changes to the Temp sheet....I'm also trying my utmost to understand that part.