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! |
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! |
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! |
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! |
All times are GMT +1. The time now is 05:55 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com