Hyperlink tabs in same worksheet at once.

May 25, 2012 at 09:15:32
Specs: Windows 7
I have an excel sheet with multiple tabs 100 plus. I have a master sheet where in column D, I have linked column C1 of all the 100 plus tabs. Now I want to create hyperlinks in column D which already is linked with all the tabs. How can i convert those links to hyperlinks at once.

See More: Hyperlink tabs in same worksheet at once.

Report •


#1
May 25, 2012 at 09:43:33
re: "I have linked column C1 of all the 100 plus tabs..."

C1 is a cell, not a column, so I assume you mean that in Column D of your master sheet, you have formulas such as:

=Sheet2!C1
=Sheet3!C1
=Sheet4!C1

Read this thread and see if it helps. There are actually 2 different suggestions in that thread, so make sure you read through it all to see if one or the other fits your needs.

http://www.computing.net/answers/of...

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question