Thread: Pick List
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Xocial Xocial is offline
external usenet poster
 
Posts: 6
Default Pick List

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!