Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto fill an address
I have a Purchase form for our company that is locked and we can't open it to
edit. So we are trying to recreate it. One of the features was that when someone would select the "Location" the "Ship to" address would automatically fill in the rows beneath the "Location" selection dropdown. Can someone give me advice on how to execute this? Probably something like; if B4=Main Office, then T3....etc Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto fill an address
Ahmed,
Create a table of location names and addresses, with as many data fields as your might need (like address, City, State, Zip - or just an address string). Then use a formula like =VLOOKUP(LocationCell,Table,2,False) in the cell where you want the address. HTH, Bernie MS Excel MVP "Ahmed55" wrote in message ... I have a Purchase form for our company that is locked and we can't open it to edit. So we are trying to recreate it. One of the features was that when someone would select the "Location" the "Ship to" address would automatically fill in the rows beneath the "Location" selection dropdown. Can someone give me advice on how to execute this? Probably something like; if B4=Main Office, then T3....etc Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
auto-fill customer address | Excel Worksheet Functions | |||
Auto-populate, Auto-copy or Auto-fill? | Excel Worksheet Functions | |||
using auto fill edit or fill handel | Excel Worksheet Functions | |||
Can you Auto fill address in excell with a data base? | Excel Worksheet Functions | |||
Enter last name, auto fill full name & address--HOW? | Excel Discussion (Misc queries) |