A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Hyperlinks to many Sheets within a Workbook



 
 
Thread Tools Display Modes
  #1  
Old June 16th, 2009, 10:03 AM posted to microsoft.public.excel.worksheet.functions
hardeep.kanwar[_11_]
external usenet poster
 
Posts: 1
Default Hyperlinks to many Sheets within a Workbook


Hi! Experts

I have Workbook which have 98 Sheets include a "UNIQUE LIST" Which have
Names of the Sheets.

Now i want to insert Hyperlinks in the "UNIQUE LIST" to other Sheets.

Ex:

If i Click on CZ001 it take me to CZ001 Sheet. If i click on WZ009 it
take me to WZ009 and so on.

I knew how to insert the Hyperlinks but i want any Formula or Code that
will do me with in a Mintues.

MY Second Question is:

Say i Click on CZ001 it take me to CZ001 and When i click on A1 of
Sheet!CZ001 it take me to "UNIQUE LIST"

If i Click on WZ009 in "UNIQUE LIST" it take to me Sheet!WZ009, when i
Click on A1 of Sheet!WZ009 it take me to "UNIQUE LIST"

Is this Possible

Thanks in Advance

Hardeep Kanwar


--
hardeep.kanwar
------------------------------------------------------------------------
hardeep.kanwar's Profile: http://www.thecodecage.com/forumz/member.php?userid=170
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=107000

  #2  
Old June 16th, 2009, 02:03 PM posted to microsoft.public.excel.worksheet.functions
Otto Moehrbach[_2_]
external usenet poster
 
Posts: 716
Default Hyperlinks to many Sheets within a Workbook

Excel has a built-in list of sheets that you might prefer using. Look at
the bottom left corner of the screen, right above the "START" button. There
you will see left and right arrows that you normally use to scroll the sheet
tabs. Right-click anywhere within these arrows. This pops up a listing of
the sheets in the current workbook. In your case, with 98 sheets, notice
that the last listing is "More sheets". Click on that. That brings up a
scrollable listing of all sheets. Click on any sheet name and that sheet
will become the active sheet. HTH Otto
"hardeep.kanwar" wrote in message
...

Hi! Experts

I have Workbook which have 98 Sheets include a "UNIQUE LIST" Which have
Names of the Sheets.

Now i want to insert Hyperlinks in the "UNIQUE LIST" to other Sheets.

Ex:

If i Click on CZ001 it take me to CZ001 Sheet. If i click on WZ009 it
take me to WZ009 and so on.

I knew how to insert the Hyperlinks but i want any Formula or Code that
will do me with in a Mintues.

MY Second Question is:

Say i Click on CZ001 it take me to CZ001 and When i click on A1 of
Sheet!CZ001 it take me to "UNIQUE LIST"

If i Click on WZ009 in "UNIQUE LIST" it take to me Sheet!WZ009, when i
Click on A1 of Sheet!WZ009 it take me to "UNIQUE LIST"

Is this Possible

Thanks in Advance

Hardeep Kanwar


--
hardeep.kanwar
------------------------------------------------------------------------
hardeep.kanwar's Profile:
http://www.thecodecage.com/forumz/member.php?userid=170
View this thread:
http://www.thecodecage.com/forumz/sh...d.php?t=107000



  #3  
Old June 16th, 2009, 02:11 PM posted to microsoft.public.excel.worksheet.functions
Luke M
external usenet poster
 
Posts: 2,672
Default Hyperlinks to many Sheets within a Workbook

This formula:
=HYPERLINK("[Book1]'"&A2&"'!A1",A2)
will take you to cell A1 of the sheet listed in A2 on active sheet. Change
name of workbook accordingly. Copy down as needed.

Select all of your other sheets (excluuding unique list) using the
shift/ctrl key to select multiple worksheets. Now, in cell A1 input this
formula, adjusted accordingly:
=HYPERLINK("[Book1]'UNIQUE LIST'!A1,"UNIQUE LIST")
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"hardeep.kanwar" wrote:


Hi! Experts

I have Workbook which have 98 Sheets include a "UNIQUE LIST" Which have
Names of the Sheets.

Now i want to insert Hyperlinks in the "UNIQUE LIST" to other Sheets.

Ex:

If i Click on CZ001 it take me to CZ001 Sheet. If i click on WZ009 it
take me to WZ009 and so on.

I knew how to insert the Hyperlinks but i want any Formula or Code that
will do me with in a Mintues.

MY Second Question is:

Say i Click on CZ001 it take me to CZ001 and When i click on A1 of
Sheet!CZ001 it take me to "UNIQUE LIST"

If i Click on WZ009 in "UNIQUE LIST" it take to me Sheet!WZ009, when i
Click on A1 of Sheet!WZ009 it take me to "UNIQUE LIST"

Is this Possible

Thanks in Advance

Hardeep Kanwar


--
hardeep.kanwar
------------------------------------------------------------------------
hardeep.kanwar's Profile: http://www.thecodecage.com/forumz/member.php?userid=170
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=107000


  #4  
Old June 16th, 2009, 06:15 PM posted to microsoft.public.excel.worksheet.functions
hardeep.kanwar[_12_]
external usenet poster
 
Posts: 1
Default Hyperlinks to many Sheets within a Workbook


Thanks Sir,

Your first Formula done a Great Job for Me.

But Unfortunataly Second one is not. May be i am Missing some
thing.

Enclosed is the copy of my Example.

Thanks in Advance

Hardeep Kanwar


+-------------------------------------------------------------------+
|Filename: Hyperlinks Multiple Sheets.xls |
|Download: http://www.thecodecage.com/forumz/attachment.php?attachmentid=167|
+-------------------------------------------------------------------+

--
hardeep.kanwar
------------------------------------------------------------------------
hardeep.kanwar's Profile: http://www.thecodecage.com/forumz/member.php?userid=170
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=107000

  #5  
Old June 17th, 2009, 09:03 AM posted to microsoft.public.excel.worksheet.functions
hardeep.kanwar[_13_]
external usenet poster
 
Posts: 1
Default Hyperlinks to many Sheets within a Workbook


hardeep.kanwar;383301 Wrote:
Thanks Sir,

Your first Formula done a Great Job for Me.

But Unfortunataly Second one is not. May be i am Missing some
thing.

Enclosed is the copy of my Example.

Thanks in Advance

Hardeep Kanwar


Pls Help me


--
hardeep.kanwar
------------------------------------------------------------------------
hardeep.kanwar's Profile: http://www.thecodecage.com/forumz/member.php?userid=170
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=107000

  #6  
Old June 18th, 2009, 08:48 AM posted to microsoft.public.excel.worksheet.functions
hardeep.kanwar[_15_]
external usenet poster
 
Posts: 1
Default Hyperlinks to many Sheets within a Workbook


No Reply from ur side Sir,


Pls Help



Luke M;382842 Wrote:
This formula:
=HYPERLINK("[Book1]'"&A2&"'!A1",A2)
will take you to cell A1 of the sheet listed in A2 on active sheet.
Change
name of workbook accordingly. Copy down as needed.

Select all of your other sheets (excluuding unique list) using the
shift/ctrl key to select multiple worksheets. Now, in cell A1 input
this
formula, adjusted accordingly:
=HYPERLINK("[Book1]'UNIQUE LIST'!A1,"UNIQUE LIST")
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"hardeep.kanwar" wrote:


Hi! Experts

I have Workbook which have 98 Sheets include a "UNIQUE LIST" Which

have
Names of the Sheets.

Now i want to insert Hyperlinks in the "UNIQUE LIST" to other

Sheets.

Ex:

If i Click on CZ001 it take me to CZ001 Sheet. If i click on WZ009

it
take me to WZ009 and so on.

I knew how to insert the Hyperlinks but i want any Formula or Code

that
will do me with in a Mintues.

MY Second Question is:

Say i Click on CZ001 it take me to CZ001 and When i click on A1 of
Sheet!CZ001 it take me to "UNIQUE LIST"

If i Click on WZ009 in "UNIQUE LIST" it take to me Sheet!WZ009, when

i
Click on A1 of Sheet!WZ009 it take me to "UNIQUE LIST"

Is this Possible

Thanks in Advance

Hardeep Kanwar


--
hardeep.kanwar

------------------------------------------------------------------------
hardeep.kanwar's Profile: 'The Code Cage Forums - View Profile:

hardeep.kanwar'
(http://www.thecodecage.com/forumz/member.php?userid=170)
View this thread: 'Hyperlinks to many Sheets within a Workbook - The

Code Cage Forums'
(http://www.thecodecage.com/forumz/sh...d.php?t=107000)




--
hardeep.kanwar
------------------------------------------------------------------------
hardeep.kanwar's Profile: http://www.thecodecage.com/forumz/member.php?userid=170
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=107000

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:46 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.