Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can you hyper link adobe reader files into excel | Excel Discussion (Misc queries) | |||
Hyper link To PDF | Excel Discussion (Misc queries) | |||
Why Excel creates hyper link in case of formula. | Excel Discussion (Misc queries) | |||
Using Excel link (hyper?) and list functions | Excel Worksheet Functions | |||
Hyper link within same workbook | Excel Worksheet Functions |