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).

do you mean like this:-

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



-----Original Message-----
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).

.

Does this require a user function.


-----Original Message-----
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).

.

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

-------------------


--
Message posted from http://www.ExcelForum.com

Yes this does.

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


-----Original Message-----
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).

.

.