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