Copy hyperlink from one workbook based off user defined selection on another.

Okay here goes. I have two workbooks. They are masterlist.xls and SOP Review.xls. The masterlist contains several hundred hyperlinks to documents. When the documents are updated I change the hyperlink on that workbook. SOP Review is a seperate sheet that I would input data to based upon a persons need to review an SOP or if a new SOP has been issued. I have user forms for both sheets. SOP Review has the user make a series of selections. Based on that data I want to be able to take the selected value in SOP Review userform1 combobox3 and search masterlist.xls (sheet)master list for that value then copy that hyperlink value and place it in SOP Review userform1 frame1 label9 and have that label change as the value in combobox3 changes. I hope that I have described my problem well enough. I have been at it all day and am feeling a little brain died. I am going to attach both sheets so everyone can look and see what it is that I am talking about. Thanks in advance for everyones help.

qppg

Hello Qppg,

I made a few changes to the SOP Review workbook. Have a look and let me know if this what you it to do.

Sincerely,
Leith Ross

Thanks for your reply, but I am not sure it is doing what I need. Is there a way based on the users selected value in the combobox3 ie (250-W005) to search the master list(workbook) sheet1 for that value in range A2:A304, find it copy the cell and paste it as the label in Frame1. Maybe it is not possible with a label. Essential what I need is the cell off of master list copied over to place on the userform with the hyperlink value intact. I hope that I am making sense. Thanks again for your help

Okay....I think that I have come to the conclusion that what I want to do can not be done. However I think that I can work around that with a little help. Instead of coyping the cell value into the lable1.value I would be happy with when the user selects the SOP name that it takes them to the Master List sheet(master list.xls) and to the cell that contains the value in Combobox3(SOP List.xls) Then the user could click the link from there and review the document. I am already using the find method to conrol the value in combobox3

Please Login or Register  to view this content.

is it possible to use this result to take the user to that sheet and cell where the value was found. Thanks again for your help. I really appreciate it.

Bob