Need to have a dropdown list containing multiple rows

[patxlb]

I am setting up an form and need to create a dropdown list that will
contain 8 sets of data. Each set needs to contain 3 rows of data
(name, street address & city/state/zip. The goal is to allow the user
to click onto the cell, see the dropdown and select which address set
to use. This would then place the data into three rows suitable for
mailing.

I have never attempted anything like this and am in need of
assistance.

Thank you.

 

[Gord Dibben]

Pat

What you ask is easily done using Data Validation drop-down list and a few
Vlookups but........Excel as a label creator is not the best tool.

If you intend to use these sets as mailing labels or for envelopes you would
be much better off to use the Mail Merge features of Word, with your Excel
addresses as the data source.

Once set up in Word, queries are easily set up to filter out the address set
you want.

For more info on merging with Word.

http://www.mvps.org/dmcritchie/excel/mailmerg.htm

http://www.mvps.org/word/FAQs/MailMerge/CreateAMailMerge.htm

http://www.mvps.org/word/FAQs/MailMerge/CreateADataSource.htm

Gord Dibben Excel MVP