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 |
Hyper link in Excel
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 |
All times are GMT +1. The time now is 05:59 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com