Multiple ListBoxes Listing Several Matches automatically

[tony75]

Morning Guys


This is what I consider a challenge (probably not for you )! I was wondering if what I'm requesting is possible. I have a UserForm with 4 ListBoxes, each one of them related to a different worksheet. what I would like them to do is, once the button "Upload List" pressed, to Populate Listbox1 using the data in "Returns" Sheet. Then, if a row within that same ListBox is highlighted, it would automatically populate the other 3 ListBoxes if the Code matches. To finish, I would like to select any row in the Listboxes and delete it on the sheet. Is this acceptable and doable?


thanks in advance

[owenaldridge]

Hi Tony,

I've put the attached workbook together, let me know if this is what you required.

Thanks

Owen

[tony75]

hi Owen


Amazing that's exactly what I needed.


Thank you very much!!!