Pick List

[Xocial]

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!

 

[Gord Dibben]

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

 

[Xocial]

Yes, I am looking to copy the checked items to another worksheet. How do I
create the checkboxes on the primary list, where I can select the items that
will copy over to another worksheet? Thank you.

 

[Gord Dibben]

Did you explore the options found at Debra's site for VLOOKUP and DV dropdown
lists for selecting an item?


Gord