| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I Create It? Inventory/pull list
I am trying to create a invoice/pull list for a warehouse in excel. I need
to know if there is a way for me to put a item name in and it pull up everthing that should be pulled for that item? For example: A customer would like a tent if I enter 10*12 tent it pulls up 4 tent sides 1 pop up tent stakes Is that possible? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can I Create It? Inventory/pull list
Sounds like dependent data validation may be of use to you - Debra
Dalgleish shows how he http://www.contextures.com/xlDataVal02.html You could then use VLOOKUP formulae to bring across related data. Hope this helps. Pete On Dec 19, 12:43 am, Kel wrote: I am trying to create a invoice/pull list for a warehouse in excel. I need to know if there is a way for me to put a item name in and it pull up everthing that should be pulled for that item? For example: A customer would like a tent if I enter 10*12 tent it pulls up 4 tent sides 1 pop up tent stakes Is that possible? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create Index for Excel Inventory List | New Users to Excel | |||
| I would like to create a coin inventory using a data template. | Excel Discussion (Misc queries) | |||
| How can i get an inventory list that adds and subtracts inventory | Excel Discussion (Misc queries) | |||
| create a inventory of files on computer in excel | Excel Discussion (Misc queries) | |||
| How do I create a spreadsheet to track monthly inventory | New Users to Excel | |||
Linear Mode
