how do I drag and fill hyperlinks?
in [Functions]
|
Prev: Data Encryption
Next: COUNTIFS equivalent in Excel 2003 - both criteria have text, one has "wildcard"
From: coreygreat on 19 Apr 2010 16:04 I have a master lists of document names that I'm trying to hyperlink sections to different sheets in the same workbook. I can't seem to figure out how to drag and fill the hyperlink in a section of the column of the mastersheet, and sequentially fill down (=sheet2!A5) to (=sheet2!A6)...and so on...linking to sequential cells in a different worksheet. Right now, I have to 'edit hyperlink' and change the cell value each time...I have 3000 to do! Thank you for your help.
From: Marcelo on 19 Apr 2010 16:40 on an auxiliar sheet try =iserror(sheet1!1:1048576) hth -- pleae click yes if it was helpfull regards from Brazil Marcelo "coreygreat" escreveu: > I have a master lists of document names that I'm trying to hyperlink sections > to different sheets in the same workbook. I can't seem to figure out how to > drag and fill the hyperlink in a section of the column of the mastersheet, > and sequentially fill down (=sheet2!A5) to (=sheet2!A6)...and so on...linking > to sequential cells in a different worksheet. Right now, I have to 'edit > hyperlink' and change the cell value each time...I have 3000 to do! Thank > you for your help.
From: Marcelo on 19 Apr 2010 16:53 oh god I am sorry I have posted wrong message thanks -- pleae click yes if it was helpfull regards from Brazil Marcelo "Marcelo" escreveu: > on an auxiliar sheet try > > =iserror(sheet1!1:1048576) > > hth > -- > pleae click yes if it was helpfull > regards from Brazil > Marcelo > > > > "coreygreat" escreveu: > > > I have a master lists of document names that I'm trying to hyperlink sections > > to different sheets in the same workbook. I can't seem to figure out how to > > drag and fill the hyperlink in a section of the column of the mastersheet, > > and sequentially fill down (=sheet2!A5) to (=sheet2!A6)...and so on...linking > > to sequential cells in a different worksheet. Right now, I have to 'edit > > hyperlink' and change the cell value each time...I have 3000 to do! Thank > > you for your help.
From: Don Guillett on 20 Apr 2010 09:10
Instead of all of that overhead simply right click sheet tab>view code>insert this. Now when you double click on any cell with a ! in the value such as sheet2!a1, you will go there. So enter sheet2!a5 and copy down. NO hyperlinks. Private Sub Worksheet_BeforeDoubleClick _ (ByVal Target As Range, Cancel As Boolean) On Error Resume Next whereat = InStr(ActiveCell, "!") ms = Left(ActiveCell, whereat - 1) mc = Mid(ActiveCell, whereat + 1, 9999) Application.Goto Sheets(ms).Range(mc) End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software dguillett(a)gmail.com "coreygreat" <coreygreat(a)discussions.microsoft.com> wrote in message news:F05F0633-B9FF-495A-9B9E-F636506E29DE(a)microsoft.com... >I have a master lists of document names that I'm trying to hyperlink >sections > to different sheets in the same workbook. I can't seem to figure out how > to > drag and fill the hyperlink in a section of the column of the mastersheet, > and sequentially fill down (=sheet2!A5) to (=sheet2!A6)...and so > on...linking > to sequential cells in a different worksheet. Right now, I have to 'edit > hyperlink' and change the cell value each time...I have 3000 to do! Thank > you for your help. |