jump to cell

[raj_tomerin]

I have two columns A and B. Suppose i write 3 in Cell A1, then I want 3 goes to B3. in the same way if i write 5 in cll A2 then i want 5 goes to B5.
So my problem is that whatever i write in any cell of column A (i.e. cell value. from 1 to 100) that value must go to the respective cell in column B ( i.e. B1 to B100). Is there any solution or macro for it. Please help

 

[circledchicken]

Hi Raj,

Right-click on the worksheet tab name, click on View Code and paste in the following (this relies on the Worksheet Change event as explained here - http://www.ozgrid.com/VBA/run-macros-change.htm):

Private Sub Worksheet_Change(ByVal Target As Range)

If Not Intersect(Target, Range("A1:A100")) Is Nothing Then
    Range("B" & Target.Row) = Target
End If

End Sub

Is there a reason you need code to do this rather than just having the formula: =A1 in cell B1 and dragged down to B100?