Hi,

I hope someone can help me with the following problem:


I will be creating a database of contact information on worksheet2. This information will be formatted as follows and I will be adding to it over time with hundreds of different contacts:

Column A – Company
Column B – Contact name
Column C - Telephone
Column D – Email Address

On worksheet1 I will set up a document which will require the information within worksheet2 to be displayed, but I will only want to show up to 30 contacts at any given time which are chosen by me.

I want to be able to create a drop down list in worksheet1 where I can “cherry pick” the contacts listed in worksheet2 so that they are added into my document in worksheet1.

Basically so it lists my “cherry picked” contacts as follows on worksheet1:


Column A B C D
Row
1 Company Contact Name Telephone Email
2 Company Contact Name Telephone Email
3 Company Contact Name Telephone Email
4 Company Contact Name Telephone Email
Ect.. Ect.. Ect… Ect… Ect…



I've confused myself trying to explain it so I hope someone will be able to understand my problem and help?


Thanks