ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Import Data in Designated Cells in Excel 2003 (https://www.excelbanter.com/excel-discussion-misc-queries/200241-import-data-designated-cells-excel-2003-a.html)

iris

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

Leo Rod

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





All times are GMT +1. The time now is 03:54 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com