Hi,

Ok, this is a bit of a puzzle to me. I can't figure out how to do it.

I have a "database" file on sheet 2. The database various informations
about different golf courses. The drop down list entries are the entries
in coloumn A. The informations about each golf course are located in the
row corresponding to the list entry. Eg.

Course 1 Par Hole information etc
Course 2 Par Hole information etc
Course 3 Par Hole information etc


The drop down list is placed on sheet 1. What I want is to have Excel
copy the course informations (Par and Hole information etc) into certain
cells on sheet 1 when the course is selected from the drop down list. So
if I choose Course 3, I would have the informations about Course 3
written in certain cells on sheet 1.

How to I do this?

I have the drop down list (made using the Data Validation menu) and my
course database. I just need to have the data copied.

I figured that it needed to be done using a macro, but I can't figure
out how to write that macro (can't really figure out the code) and I
can't assign a macro to the drop down list.

A solution could of course be to insert a button besides the drop down
list and then assign the macro (which I still don't have) to the button.

Maybe someone could help me out? :-)

Anders

Anders -

For the fields you want to populate with information, you can use a VLOOKUP
into your "database" file using the value of the cell with the drop-list.
You would want to code the field to be blank if the cell with the drop-list
is empty.

--
Daryl S


"Anders" wrote:

Hi,

Ok, this is a bit of a puzzle to me. I can't figure out how to do it.

I have a "database" file on sheet 2. The database various informations
about different golf courses. The drop down list entries are the entries
in coloumn A. The informations about each golf course are located in the
row corresponding to the list entry. Eg.

Course 1 Par Hole information etc
Course 2 Par Hole information etc
Course 3 Par Hole information etc


The drop down list is placed on sheet 1. What I want is to have Excel
copy the course informations (Par and Hole information etc) into certain
cells on sheet 1 when the course is selected from the drop down list. So
if I choose Course 3, I would have the informations about Course 3
written in certain cells on sheet 1.

How to I do this?

I have the drop down list (made using the Data Validation menu) and my
course database. I just need to have the data copied.

I figured that it needed to be done using a macro, but I can't figure
out how to write that macro (can't really figure out the code) and I
can't assign a macro to the drop down list.

A solution could of course be to insert a button besides the drop down
list and then assign the macro (which I still don't have) to the button.

Maybe someone could help me out? :-)

Anders
.

Daryl S skrev:
Anders -

For the fields you want to populate with information, you can use a VLOOKUP
into your "database" file using the value of the cell with the drop-list.
You would want to code the field to be blank if the cell with the drop-list
is empty.

Thanx, that was just the function I needed!

Anders