Database Drop Down menu

**nealwakenshaw** · 01-05-2011, 07:30 AM

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

**alansidman** · 01-05-2011, 09:03 AM

Neal;
Is this in Access or Excel that you are trying to do this. I am confused as you posted in an Access forum and use Excel terms?

There are no worksheets, rows or columns in Access. There are tables, forms, records, fields and controls. Please clarify and if this is an Excel question, request a moderator to move your thread to an Excel forum
Alan

**NBVC** · 01-05-2011, 09:13 AM

I am assuming this is an Excel question posted in the wrong forum because of the terminology used.

I can suggest a possibly easier alternative....

In Sheet1, in column E, enter a symbol, like an "x" for each item you want to transfer... then in F2 enter formula:

=IF(E2="x",COUNT(F$1:F1)+1,"") copied down.

in Sheet2:

In say, G1 enter formula: =MAX(Sheet1!F:F)

In A2, enter formula: =IF(ROWS($A$1:$A1)>$G$1,"",INDEX(Sheet1!A:A,MATCH(ROWS($A$1:$A1),Sheet1!$F:$F,0)))

where sheet1 is the name of your Sheet1.... adjust as necessary.

then copy down 30 rows (or more) and across 5 columns.

P.s. I will move this to the Excel General forum