it's an excel world
- Sep 17, 2008
I was wondering if it was possible to have hyperlinks linked to a secondary sheet that is linked from a "main" sheet (not sure if that is phrased correctly or not). Anyway.... I have a spreadsheet that I have one person maintain information on to help identify incoming inventory for everyone in the department. I also have a secondary sheet that is read only and links from the first using formulas so that all the info on the first sheet is visible on the second sheet. This was done so that we did not have to be concerned with some users compromising the integrity of the information. In addition what I would like to do is create hyperlinks in the first sheet to pictures of the invetoried items but second sheet doesn't seem to pick up these hyperlinks. Any thoughts? Thanks for your time.