Hi,

I have 5 tables all named table1 table2 etc. They are all on the same worksheet and in the same columns placed beneath one another.

I have created a userform which has 5 Listboxes all named listbox1 listbox2 etc. Each listbox is populated by the tables eg listbox1 is populated by table1.

My goal is to select multiple items (rows) in a listbox eg listbox1, click a button captioned "Move to", a new userform will pop up allowing me to select another listbox eg listbox3, it then moves the selected items to listbox 3 and updates the tables on the worksheet showing the same changes.

I hope this is clear enough.

Thanks for any help in advance