| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Can you Auto fill address in excell with a data base?
I am trying to link a database to a shiping document. I need it to
automaticly fill in the address and phone numbers of the venders the equiptment is being shipped to. I can not seem to find any tools in Excel that can do this. Is it possible? |
|
#2
|
|||
|
|||
|
you need to use a vlookup table,with your suppliers in the lh column and the
respective address's,etc in the next column.when you select your vendor the address will be returned .You can use your list of vendors as the input range for a drop down box to select your vendor. -- paul remove nospam for email addy! "bayou beot" wrote: I am trying to link a database to a shiping document. I need it to automaticly fill in the address and phone numbers of the venders the equiptment is being shipped to. I can not seem to find any tools in Excel that can do this. Is it possible? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Importing unopened worksheet into an open Workbook | Excel Discussion (Misc queries) | |||
| Series fill of "patchy" Data set or some Programming fix | Excel Worksheet Functions | |||
| Changing the auto fill order from ascending to descending | Excel Discussion (Misc queries) | |||
| auto fill data into a cell from a lookup table | Excel Discussion (Misc queries) | |||
| Auto filling dates on other worksheets with data from a next payme | Excel Worksheet Functions | |||
Linear Mode
