View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] praveen221273@gmail.com is offline
external usenet poster
 
Posts: 2
Default 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