Go to the Summarised Statement worksheet, right-click on its name tab and
choose [View Code] from the list that appears. Copy the code below and paste
it into the code module that appears. Then close the Visual Basic Editor.
After that, when you click/choose a single cell in column A, its value will
appear in L3 on the Report sheet. Macros must be enabled for this to work.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Column = 1 And Target.Cells.Count = 1 Then
ThisWorkbook.Worksheets("Report").Range("L3") = _
Target.Value
End If
End Sub


" wrote:

Hi,

I badly needs someones help on this

I have 2 sheets
Namely
Sheet1=Summarised Statement
Sheet2=Report

In Sheet 1 the A coulmn is loaded with ID starting from
1,2,3............ and so on.

These ID's are hyperlinked to cell L3 in Report

On clicking 1 want the value of the clicked cell in sheet 1 to apprear
on L3 in Report

Please help on this

Thanks