Assigning one cell the value of another cell

[excelnovicepleasehelp]

This is probably basic for many/most of you, but I've been trying to figure out how to do this for a couple of hours now.....

Very simple, I have a spreadsheet with various values assigned to each cell. On top of the spreadsheet, I have a formula to calculate the result I am looking for. I would like to assign cell A1 with the value of whatever the value is for the cell within the spreadsheet that is currently hightlighted (e.g. cell D4 = 15, if I land the cursor on cell D4, I want cell A1 to automatically take on the value of 15.

Any help would be greatly appciated.

 

[AlphaFrog]

Right-click on the sheet tab and select View Code from the pop-up menu. Paste the code below in the VBA edit window.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

    Range("A1").Value = Target(1).Value

End Sub

 

[VoG]

Right click the sheet tab, select View Code and paste in

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Range("A1").Value = Target.Value
End Sub

 

[excelnovicepleasehelp]

worked perfectly....thanks guys