Help Please !!!

[Craig]

Looking for some help if anyone can solve :
If i have a number in a cell and then want to place that
number in another cell, which will be determined by a
number put in another cell.
EG A2 = 1200 (Inputted value), need to put this number
(1200) in cell E1. This cell number is determined by
number put into cell A3 (5).

 

[GUESSWHO]

do you mean like this:-

at cell E1 =if(condition,true,false)
ex : =if(A3=5,+A2,0)

 

[Guest]

Does this require a user function.

 

[Colo]

Cell number stands for Column # ?


Code
-------------------

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address(0, 0) <> "A2" Then Exit Sub
If Not IsNumeric([A3].Value) Then Exit Sub
Cells(1, [A3].Value).Value = Target.Value
End Sub

 

[Guest]

Yes this does.

-----Original Message-----
Does this require a user function.


.