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