View Single Post
 
Old 04-02-2013, 06:49 AM
paul_pearson paul_pearson is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Mar 2013
Posts: 5
paul_pearson is on a distinguished road
Default Multiple entries in dropdown lists

Hi

Can i create a Template with dropdown list of 35 companies to choose from using the following examples to show what i require:

If i select Roundhouse Nurseries or Smithswholesales from the list it also includes Phone Number,Fax Number and Email address for each company....can i have about 35 companies in the dropdown list to choose from....i will only select 1 company at a time as this will be for a invoice (will create a template)....i want it to show the email address but not have the blue underline

Roundhouse Nurseries
Phone: 08 1111 1111
Fax: 08 2222 2222
Email: sales@roundhousenurseries.com.au


Smiths Wholesales
Phone: 08 3333 3333
Fax: 08 4444 4444
Email: sales@smithswholesales.com.au

Thanks

Paul
Excel 2010
Reply With Quote