Import Data in Designated Cells in Excel 2003

I

Iris

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?
 
L

Leo Rod

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2003 Form-Import data in designated cells 3
Importing data from Excel worksheet into Excel template 2
import multiple excel books to one excel workbook 3
Where is the Data Import Excel button in Excel 2007 6
Import more than one .csv file into the same Excel file. 1
excel 2010 + copy array 3
How do I import data from a text file into Excel 2003 2
External Data Refresh Issues 0

Top