Ref a cell with a hyperlink from multiple worksheets

**Qppg** · 10-24-2007, 02:28 PM

Here goes,
I have spent quite a bit of time trying to data mine the answer to my questions so as not to waste peoples time on an issue that has a answer already. So if I have missed that I apologize in advance and would gladly read that thread if provided a link to it.

At any rate this is what I am trying to do. I work in a manufactuing environment which requires us to use SOP(standard operating procedures) We have an excel sheet that has a master list of all the plant SOP's. Then we have numerous other sheets(with in the same work book) that break down the needed SOP's by department. I have created hyperlinks from the the master list to all the appropriate file locations no problem. What I would like to do is find away to reference specific hyperlinks from the master sheet on corresponding department sheets so if the SOP is revised later that when I update the master sheet hyperlink the corresponding reference's on the department sheets will update with the new hyperlink address.

I am fairly proficient with excel and can crawl my way through some basic VB, so any advice or help would be greatly appreciated. If you need some more specific information I will gladly provide it. I will also attach the file that I am working with so people can see exactly what it is I am trying to do.

Thanks again,
Qppg

**Steve R** · 10-24-2007, 05:02 PM

Try =HYPERLINK(""&Sheet1!A15&"") on the other sheets, not master sheet.

Sheet1!A15& is the address to the master sheet and cell, containing the hyperlink.

**Qppg** · 10-24-2007, 05:53 PM

Steve,
Thanks for the suggestion....I tried it and it copied everything over fine but when I click the new link I get an error message that reads The address of this site is not valid. Check the address and try again. Any other thoughts?

Thanks again
qppg

**Steve R** · 10-24-2007, 06:01 PM

Can you attach the file you are working with?

**Qppg** · 10-24-2007, 06:59 PM

Sorry about that I thought that I had attached it with my original post. I will have to attach it tomorrow morning as I am at home and my computer is having trouble accessing my work network drives. I will attempt again to attach the file tomorrow morning. Thanks again for your help

qppg
Go Rockies

**Qppg** · 10-25-2007, 08:35 AM

Steve,
Here is the file. Thanks again for your help.

**Steve R** · 10-25-2007, 03:31 PM

In the masterlist you need a new column showing the filepath.

It is not possible to use hyperlinks on the other sheets, since the it is not the filepath that is shown in the Masterlist.

Read more: Links to hyperlinks

**Qppg** · 10-25-2007, 06:23 PM

Steve,
Thanks for all your help. I understand what you are saying in your previous post, but I choose to use an alterniative route. This is what I am going to use It accomplishes the same thing basically.

 Private Sub cmdQualityResponsibilities_Click()
    Me.Hide    'hides the user form
    Sheet4.Activate    'makes the Quality Responsibilities sheet viewable
    
Sheet1.Range("a287:a301").Copy
Sheet4.Select
Sheet4.Range("a6:a20").Select
Sheet4.Paste
'
Sheet1.Range("a285:a286").Copy
Sheet4.Select
Sheet4.Range("a3:a4").Select
Sheet4.Paste


End Sub

Thanks again for your help I truely appreciate it.
qppg