I have a main worksheet with a Data Validation Drop Down List. There is
another worksheet where I have the list/s of information, I have called
INFO1. Let's say the first cell in the main sheet is K7. The data on the
INFO1 worksheet is in the following format:
A B
1 Red R
2 Green G
3 Blue B
4 Purple P
When I click on K7, I get the drop down list of A1 thru A4, and making a
selection returns the value in column A I clicked on. What I want to happen
is when I click on a cell in column A it will then return the value in column
B only in cell K7. i.e. click A2 returns G in cell K7. Hope I have asked
this correctly. thanks for the help......... Bill

You need an event sub for that:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Worksheets("main").Range("K7") = Cells(Target.Row, Target.Column + 1)
End Sub

Post if you need help to install it!
Regards,
Stefi

€žretired bill€� ezt Ã*rta:

I have a main worksheet with a Data Validation Drop Down List. There is
another worksheet where I have the list/s of information, I have called
INFO1. Let's say the first cell in the main sheet is K7. The data on the
INFO1 worksheet is in the following format:
A B
1 Red R
2 Green G
3 Blue B
4 Purple P
When I click on K7, I get the drop down list of A1 thru A4, and making a
selection returns the value in column A I clicked on. What I want to happen
is when I click on a cell in column A it will then return the value in column
B only in cell K7. i.e. click A2 returns G in cell K7. Hope I have asked
this correctly. thanks for the help......... Bill

Stefi - Thanks for your reply. I'm very new to this, and am sorry to say I
do not know what an event sub is or how to use/post/install. Would
appreciate any and all help you may give to a new guy. This one I cannot
figure out. Thanks, Bill

"Stefi" wrote:

You need an event sub for that:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Worksheets("main").Range("K7") = Cells(Target.Row, Target.Column + 1)
End Sub

Post if you need help to install it!
Regards,
Stefi

€žretired bill€� ezt Ã*rta:

I have a main worksheet with a Data Validation Drop Down List. There is
another worksheet where I have the list/s of information, I have called
INFO1. Let's say the first cell in the main sheet is K7. The data on the
INFO1 worksheet is in the following format:
A B
1 Red R
2 Green G
3 Blue B
4 Purple P
When I click on K7, I get the drop down list of A1 thru A4, and making a
selection returns the value in column A I clicked on. What I want to happen
is when I click on a cell in column A it will then return the value in column
B only in cell K7. i.e. click A2 returns G in cell K7. Hope I have asked
this correctly. thanks for the help......... Bill