Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Data Validation
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. The range I would like this to work in is K7.K56. Hope I have asked this correctly. thanks for the help......... Bill |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Data Validation
You would need to use event code, like Worksheet_Change.
Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Range("A:A") Is Nothing Then Range("K7") = Target.Offset(0, 1).Value End If End Sub Copy this snippet to you sheet code module by right clicking the sheet name tab, then click View Code in the pop up menu to open the code window. "retired bill" wrote in message ... 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. The range I would like this to work in is K7.K56. Hope I have asked this correctly. thanks for the help......... Bill |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
custom data validation on cells with data validation values | Excel Worksheet Functions | |||
Validation Data using Validation Table cell range..... | Excel Discussion (Misc queries) | |||
data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
data validation invalid in dynamic validation list | Excel Programming | |||
Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) |