Pete,

I have a worksheet that contains street intersections and other important
information about them. Column €œA€� has the intersections unique identifier
number and €œE€� is the common name for each intersection. Each cell of €œE€�
also has an associated hyperlink path to a .pdf file on our network that has
pictures, plans, ect. This hyperlink is hidden though and can only be seen
when holding the cursor over the cell.

There are a few hundred intersections controlled by 5 engineers. What I
want to do is take each engineers worksheet of intersections and populate a
master list of all intersections on one worksheet so everyone can see the
information and fallow the hyperlinks.

A majority of the information in each engineers worksheet is updated/changed
often so its important that a continuous referencing or updating to the
master sheet occurs. Secondary need is to have each engineers worksheet
(tab) protected that only they can edit it.


I am using a €˜Vlookup formula to reference each engineers information to a
master sheet, but I cant get the imbedded hyperlinks of column €œE€� to
reference. They just appear as simple text. €˜Vlookup is looking for the
unique identifier number of each intersection is column €œA€� of an engineers
tab, €œGreg only€� and then populates the main sheet with each found row.
=VLOOKUP($A12,'Greg only'!$A$3:$AE$120,E$1,FALSE)

I can use =Hyperlink(*above formula*) but all this does is turns every cell
into a visible hyperlink with a path of its own cell text.


At this time I do not care if all sheets are in the same workbook. They can
all be separate or together. I figured all sheets could be in the same
workbook, that way anyone wanting to see the master list could also just view
by particular engineer.


Hope this is clear. Thanks again for any help