Help Please !!!
 

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

Help Please !!!
 

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

.

Help Please !!!
 

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

.

Help Please !!!
 

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

Help Please !!!
 

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

.

.