hardeep
06-20-2009, 05:03 AM
Hi! Experts
I have Workbook which have 98 Sheets include a Sheet1!"UNIQUE LIST" Which have Names of the Sheets.
Now i want to insert Hyperlinks in the Sheet1!"UNIQUE LIST" to other Sheets.
Ex:
If i Click on A2(CZ001) it take me to Sheet!CZ001 . If i click on A78(WZ009) it take me to Sheet!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 Sheet!CZ001 and When i click on A1 of Sheet!CZ001 it take me to Sheet1!"UNIQUE LIST"
If i Click on WZ009 in Sheet1!"UNIQUE LIST" it take to me Sheet!WZ009, when i Click on A1 of Sheet!WZ009 it take me to Sheet!"UNIQUE LIST"
Is this Possible
Thanks in Advance
Hardeep Kanwar
I have Workbook which have 98 Sheets include a Sheet1!"UNIQUE LIST" Which have Names of the Sheets.
Now i want to insert Hyperlinks in the Sheet1!"UNIQUE LIST" to other Sheets.
Ex:
If i Click on A2(CZ001) it take me to Sheet!CZ001 . If i click on A78(WZ009) it take me to Sheet!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 Sheet!CZ001 and When i click on A1 of Sheet!CZ001 it take me to Sheet1!"UNIQUE LIST"
If i Click on WZ009 in Sheet1!"UNIQUE LIST" it take to me Sheet!WZ009, when i Click on A1 of Sheet!WZ009 it take me to Sheet!"UNIQUE LIST"
Is this Possible
Thanks in Advance
Hardeep Kanwar