Hyper link in Excel
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
|