Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Forms
We use an excel 2000 form as an order form.
We enter the customer "bill to address" manually. What is the best way to get excel to automatically fill in the "bill to address" cells based on data entered in a "customer number" cell. We have a separate excel worksheet with "customer numbers" and "bill to" data. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Forms
We use an excel 2000 form as an order form.
We enter the customer "bill to address" manually. What is the best way to get excel to automatically fill in the "bill to address" cells based on data entered in a "customer number" cell. By cell do you mean an input box on the form ? If so you can use the onChange event to trigger some code to look through a range in your customer numbers work sheet and pull the address. We have a separate excel worksheet with "customer numbers" and "bill to" data. Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Forms
Take a look at the =vlookup() worksheet function.
If your separate sheet is named CustomerData and your custnumbers are in column A and the Bill-to address is in column B: =if(c3="","",vlookup(c3,customerdata!a:b,2,false)) (if you put the customer number in C3.) Kord wrote: We use an excel 2000 form as an order form. We enter the customer "bill to address" manually. What is the best way to get excel to automatically fill in the "bill to address" cells based on data entered in a "customer number" cell. We have a separate excel worksheet with "customer numbers" and "bill to" data. Thanks -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Forms | New Users to Excel | |||
forms | Excel Discussion (Misc queries) | |||
Forms | Excel Worksheet Functions | |||
Pop Up Forms | Excel Discussion (Misc queries) | |||
Forms | Excel Programming |