Move Userform Listbox selected items to another worksheet

Hello,

I would like to create a Userform which requires the user to check through the items in a Listbox and click a command button to move the items to another sheet (Sheet2).

The Listbox Rowsource is a dynamic named range (=Sheet1!$A$2:INDEX(Sheet1!$1$65535,COUNTA(Sheet1!$A:$A),COUNTA(Sheet1!$1:$1))

There are data contain in Sheet1 columns A to L.

I need a code for command button to move/copy selected items in the Listbox to Sheet2, then delete the same selected items in Sheet1 and refresh the Listbox, so that it appears relatively seamless to user.

Thanks!

-Jay

Attached a demo file, note rowsource is not used, the use of Tables is far more stable method.

Thanks torachan!

How do i display the ColumnHeads? it just shows a blank row even though i selected from the listbox properties.

You can only apply column heads with the rowsource loading method.