| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Import Data in Designated Cells in Excel 2003
I created a proposal form in excel 2003. When I select a customer name, I
want excel to import the data that relates to the customer. I have several worksheets in one workbook that contain the data. Does someone have a simple solution? -- Iris |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Import Data in Designated Cells in Excel 2003
Try using the 'vlookup' formula having the target set to these other
workbooks where the information is stored; if what you want is a change whenever you variate a value in a cell -e.g. name- use the function 'if' together with 'vlookup. Check the Excel help for additional info on these functions, it's very clear :-) Greetings, Leo Rod MIA, Fl. USA "Iris" wrote in message ... I created a proposal form in excel 2003. When I select a customer name, I want excel to import the data that relates to the customer. I have several worksheets in one workbook that contain the data. Does someone have a simple solution? -- Iris |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 Data Import from SQL | Excel Worksheet Functions | |||
| Excel 2002: How to tranpose data to designated cells ? | Excel Discussion (Misc queries) | |||
| issue with excel 2003 data import | Excel Discussion (Misc queries) | |||
| Protecting sheet disables import of extetrnal data in Excel 2003 | Excel Discussion (Misc queries) | |||
| How do I import data from Microsoft Project 2003 to Excel? | Excel Discussion (Misc queries) | |||
Linear Mode
