To "move" the items will require VBA or a manual cut and paste.

To "copy" the checked items to another worksheet could be as simple as some
VLOOKUP formulas on the other sheet.

See Debra Dalgleish's site for more on VLOOKUP and Data
Validation lists for entering the choices.

http://www.contextures.on.ca/xlFunctions02.html

http://www.contextures.on.ca/xlDataVal01.html

Note the section on using DV lists from another worksheet by naming the list.


Gord Dibben MS Excel MVP

On Fri, 11 Jan 2008 07:17:01 -0800, Xocial
wrote:

Hello. The situation: I have an inventory list in an excel spreadsheet. I
would like to choose items off of it which will put the selected items in
another spreadsheet or worksheet. I would like to make it easy where I can
check a check box next to the original list. Each time I select an item it
will transfer to another worksheet.

Question: Is there a way whether through vb or natively to select items from
a list in an excel spreadsheet and each selected item will move to another
spreadsheet or worksheet?

Thank you!