Solved: Hyperlinks in Excel

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Gogs

Thread Starter
Joined
Jul 28, 2003
Messages
121
Hi Folks,

I have a spreadsheet that has a summary sheet at the start.

The summary sheet has a list of unique IDs in B2 to B201 (I have used these unique IDs as work sheet names as well for ease of reference) and next to these in Column C is the Title of the Item on that particular worksheet. eg

Unique ID Title
xyz123 First Article
xyz124 Second Article

I would like to hyperlink the Titles in column C to the worksheet matching the unique ID next to it in column B. As the data is already in the summary sheet is there an easy way to do this?

I was thinking I could edit something within the hyperlink so it picks up the value in cell B2, B3, B4 etc and this tells it what sheet to go to.

Any help appreciated.

Cheers

Gogs
 
Joined
Oct 20, 2004
Messages
7,837
You have 200 worksheets???
Whatever this is, wouldn't a database be better for that much data manipulation?
However, one way to do what you are asking is via the free Excel add-in, ASAP Utilities (which I constantly seem to be recommending) that you can get at
http://www.asap-utilities.com/
It has a function under Sheets called Create and Index Page via which it makes an index page of all the sheets in the workbook, which you could then cut and paste into another worksheet if you preferred. Then all you would have to do would be use a formula to match the Sheet names to the other list and get the unique IDs.
The only problem is that the index sheet links take you to cell A1 of the given page.
 

Gogs

Thread Starter
Joined
Jul 28, 2003
Messages
121
It's not really for Data Manipulation. It's just a quick easy way to keep track of certain documents.

That ASAP thing is brilliant. Thanks a load. I can see I'll be using it time and time again.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Top