Export multiselct listbox with nine columns

Good evening,

I have a listbox that displays nine columns' worth of results. (Multiple rows are displayed also)

The data is drawn from Sheet2.

I am trying to be able to select any given row on the listbox and export them to sheet3. This in turn deletes the selected row from Sheet1. Obviously, I would need the "cut and pasted" row to not overwite existing data on sheet3. Sheet3 has header, so all data would go from A2 onwards.

I could not find any similar request for help. The closest I could find was the row to be simply copied to another sheet.

Any help as I'm tearing my hair out.

Thank you

Hi Keith,

Course, you are right.

I've just been messing with this one. It's activated by command button 4. I'm getting somewhere - and nowhere all at the same time!

If someone can get it to make me a nice cup of tea as well....

Seems OK Leith, just downloaded and opened it...

Hi again, hoped it was OK to bump. Please let me know if there are still problems opening it.