I asked for some help a while back regarding things repeating into other forms and received phenomenal support. So I'm hoping that this problem has a similar outcome.

I have a form that I fill out constantly. It already repeats itself into other pages as mention above. However, there's a section that I fill out based on the location I want this person to go to.

There are a total of 14-15 different places I send these people to.

I then write out all the address, name, etc. Its somewhat redundant because I do it almost everyday.

What I'd love to have is a drop down list of places where I can select the right one, and then in the box below, the proper address and information automatically comes up.

Anyways I can do this?

We have Office Pro here with Word, Excel, Infopath, etc..

Any help is always appreciated.

 

something like that would have to be done in Excel.

Basically you make a drop-down combo box from the "forms" toolbar (I think). Right click and say "format control". Define your list in a separate section of cells, and then select a destination cell.

Selecting things from the list will return a number to the destination cell (I usually put this UNDER the combo box). Then, use a VLOOKUP formula to determine the address from the number returned (from numbered list along with address, state, etc in a separate sheet...the first column will contain the number).

What you want to do can't be done in word without exensive VB programming (as far as I know). Perhaps you can embed the excel into a word document if you HAVE to use word?

 

excel use it, tons of stuff. I like microsoft project also, kind of similiar for business apps if you like linking.

 

basically, its something that has to be somewhat linked to a database of sorts...

 

whats ur career?

 

It's called a lookup list in Excel. They take a bit to figure out and setup but once you have the lookups working they are fast and simple to use. Here's how to do it.

http://www.contextures.com/xlDataVal02.html

Also, the newer versions of Excel have detailed writeups in their help files about lookup lists. They are a powerful feature that people don't use often enough.