H
hardeep.kanwar
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
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