JohnEnglish
New Member
- Joined
- Jun 19, 2011
- Messages
- 7
I have a workbook with several sheets of data.
The first sheet has a list of company names in alphabetical order like this:
The remaining sheets have the actual data sets for each company and look like this:
What I'd like to do is hyperlink the names on the first sheet to the coresponding data sets on the following sheets. I know I can use the "Create Hyperlink" menu when I right click a cell but with several hundred names it'll take a while. I also played around with the "HYPERLINK" formula but I couldn't seem to get it to copy the data horizonally when I tried to autofill the cells on the first sheet vertically. Also the HYPERLINK formula only change the second part of the formula "friendly name" when I draged it. It did not change the first part of the formula "link location". I would need it to change both fields when I dragged it so it not only updated the link location but also the "friendly name" of the link.
The first sheet has a list of company names in alphabetical order like this:
The remaining sheets have the actual data sets for each company and look like this:
What I'd like to do is hyperlink the names on the first sheet to the coresponding data sets on the following sheets. I know I can use the "Create Hyperlink" menu when I right click a cell but with several hundred names it'll take a while. I also played around with the "HYPERLINK" formula but I couldn't seem to get it to copy the data horizonally when I tried to autofill the cells on the first sheet vertically. Also the HYPERLINK formula only change the second part of the formula "friendly name" when I draged it. It did not change the first part of the formula "link location". I would need it to change both fields when I dragged it so it not only updated the link location but also the "friendly name" of the link.
