Thanks for the reply Mark, but when I printed it I realized that I must have
been under the wrong part in Office. My issued is in Word not Excel.

Any ideas for MS Word?



"NoodNutt" wrote:

G'day Fly

Rather than using a macro, and or for that matter dropdowns on the
supplimental information you want to automate, I would use a LookUp.

Assumed New Lookup Sheet Name: MyLookups



A B
C D
1 Location Address
Phone Contact

2 Australia Capital City Dr, Canberra
61 2 Blah Blah Kevin Rudd (PM)
3 USA Washington Blvd, DC
Uncle Sam Bush Pig

And So On...............



On your Main User Sheet:


A B C
D
1 Location Address Phone
Contact
Dropdown B2
=IF($A1="","",(LOOKUP($A1,MyLookUps!$A$2:$D$63635, MyLookUps!$B$2:$B$63635)))
lists C2
=IF($A1="","",(LOOKUP($A1,MyLookUps!$A$2:$D$63635, MyLookUps!$C$2:$C$63635)))

D2
=IF($A1="","",(LOOKUP($A1,MyLookUps!$A$2:$D$63635, MyLookUps!$D$2:$D$63635)))

Copy down as required

HTH
Mark.