| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Select a customer name and have their address fill in automaticall
I would like to be able to select a customer naome on an order form and have
their address fill in automatically. How do I do this in excel 2007 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Select a customer name and have their address fill in automaticall
VLOOKUP formulas will pull the data to appropriate cells.
See Debra Dalgleish's site for more on VLOOKUP and Data Validation lists for entering the choices. http://www.contextures.on.ca/xlFunctions02.html http://www.contextures.on.ca/xlDataVal01.html Note the section on using DV lists from another worksheet by naming the list. Gord Dibben MS Excel MVP On Tue, 2 Oct 2007 11:21:02 -0700, Missie wrote: I would like to be able to select a customer naome on an order form and have their address fill in automatically. How do I do this in excel 2007 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I differences in two Excel Workbook lists automaticall | Excel Discussion (Misc queries) | |||
| CONVER CSV CUSTOMER DATA TO A CUSTOM INDIVI CUSTOMER PRICE SHEET | Excel Discussion (Misc queries) | |||
| How do you select a cell with an "absolute" address with a cursor? | New Users to Excel | |||
| How can I format the #of decimals, field types, etc. automaticall. | Excel Discussion (Misc queries) | |||
| Enter last name, auto fill full name & address--HOW? | Excel Discussion (Misc queries) | |||
Linear Mode
