If Function question Closed

Question

Hello,
I am trying to get 3 cells to populate with different data by only choosing data from only one cell. If a1 = xxx then cell a2 will = yyy cell a3 will = zzz, this is set data that has to appear each time this combination is used a1 is xxx all the others will always be the same data, if this make any sense could you help me get these cells to populate. Many thanks

venkat1926 · Answer

did not understand. I am  rephrasing your question
In column A wherever XXx is entered then  in the column B of the same row will be yyy and in column C of same row will be zzz.
if this understanding is correct then follow these instruction
right click the sheet tab and click view code 
in the resuting window copy paste this EVENT CODE"

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column <> 1 Then Exit Sub
If Target = "xxx" Then
Cells(Target.Row, "b") = "yyy"
Cells(Target.Row, "c") = "zzz"
End If
End Sub


Now inthe sheet in column type some entry other than xxx see what happens
again in some other cell in column A enter xxx then see what happens. 

if this is ok confirm

If Function question

1 response

Similar discussions

Subscribe To Our Newsletter!