If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
how do I drag and fill hyperlinks?
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. |
#2
|
|||
|
|||
how do I drag and fill hyperlinks?
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. |
#3
|
|||
|
|||
how do I drag and fill hyperlinks?
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. |
#4
|
|||
|
|||
how do I drag and fill hyperlinks?
Instead of all of that overhead simply right click sheet tabview
codeinsert 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 "coreygreat" wrote in message ... 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. |
Thread Tools | |
Display Modes | |
|
|