[hedbeb]

Here's a challenge for someone:
Does anyone know if it's possible to link a form field in a Word document to
the autofilter results in an excel spreadsheet? For example: assuming U.S.
was the selected country in Field1, then a macro would filter the spreadsheet
to display all the states in the U.S. and now these are the available options
in Word Field2. Then if Minnesota was selected in Field2, a macro would
filter the spreadsheet even further and now the available options in Word
Field3 would only be the cities in Minnesota...
DOES ANYONE KNOW IF THIS IS POSSIBLE TO LINK WORD FIELDS TO SPREADSHEET
FILTER RESULTS???


--
Thanks,

Brad

[Graham Mayor]

You could probably do it in conjunction with a userform - see
http://gregmaxey.mvps.org/Populate_UserForm_ListBox.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



hedbeb wrote:
Here's a challenge for someone:
Does anyone know if it's possible to link a form field in a Word
document to the autofilter results in an excel spreadsheet? For
example: assuming U.S. was the selected country in Field1, then a
macro would filter the spreadsheet to display all the states in the
U.S. and now these are the available options in Word Field2. Then if
Minnesota was selected in Field2, a macro would filter the
spreadsheet even further and now the available options in Word Field3
would only be the cities in Minnesota...
DOES ANYONE KNOW IF THIS IS POSSIBLE TO LINK WORD FIELDS TO
SPREADSHEET FILTER RESULTS???