Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cells to be populated from an workbook to another.
Hello,
Hope that someone could help me. I have an inventory in excel with the following information. Skid #, Order number, Style, Color ect... and another sheet in an other workbook that is my shpping information sheet. I would like to be able to enter only the order number in my shpping information sheet and that all other specific cells to be populated with the information related to this order number. Is it possible????? Please help, I'm a beginner in this matter. Thank you, Fred's |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cells to be populated from an workbook to another.
Sounds like a perfect chance to learn about =vlookup() or =index(match()).
Debra Dalgleish has lots of notes: http://www.contextures.com/xlFunctions02.html (for =vlookup()) and http://www.contextures.com/xlFunctions03.html (for =index(match())) and http://contextures.com/xlFunctions02.html#Trouble Fred's wrote: Hello, Hope that someone could help me. I have an inventory in excel with the following information. Skid #, Order number, Style, Color ect... and another sheet in an other workbook that is my shpping information sheet. I would like to be able to enter only the order number in my shpping information sheet and that all other specific cells to be populated with the information related to this order number. Is it possible????? Please help, I'm a beginner in this matter. Thank you, Fred's -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can a cell be automatically populated with the workbook name? | Excel Worksheet Functions | |||
Count only on visually populated cells | Excel Worksheet Functions | |||
Counting populated cells in another worksheet | Excel Worksheet Functions | |||
changing average if cells populated | Excel Worksheet Functions | |||
how do populate empty cells with the contents of populated cells . | Excel Discussion (Misc queries) |