Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pick List
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! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pick List
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" wrote: 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! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pick List
Did you explore the options found at Debra's site for VLOOKUP and DV dropdown
lists for selecting an item? Gord On Fri, 11 Jan 2008 12:47:01 -0800, Xocial wrote: 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" wrote: 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Look up list of values based on single value from pick list | Excel Discussion (Misc queries) | |||
pick from list | Excel Programming | |||
Pick List Box | New Users to Excel | |||
Making pick list conditional on selection from previous pick list | Excel Discussion (Misc queries) | |||
Pick From List | Excel Discussion (Misc queries) |