Create worksheets with links from a list
Closed
lewis_james_price
-
1 Jun 2010 à 23:56
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 2 Jun 2010 à 18:08
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 2 Jun 2010 à 18:08
Related:
- Create worksheets with links from a list
- "You can make a private videos list and share them only with your favorite friends!" - Guide
- Create bitly link - Guide
- Create skype account with gmail - Guide
- Counter strike 1.6 cheats list - Guide
- Create snapchat account with email - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
2 Jun 2010 à 10:36
2 Jun 2010 à 10:36
Not sure about what you meant by "create a new worksheet with a link from the original list". The number of sheets in a workbook depends on the amount of data and the version of excel that you are using.
2 Jun 2010 à 17:15
The end scenario I am looking for is say a list containing 50 cells. I would to be able to press on one of those cells i.e. "Mr Smith" and hyperlink to a worksheet called "Mr Smith".
Therefore, creating a type of contents page for the worksheets contained in the document.
I hope this makes sense.
Lewis.
2 Jun 2010 à 17:20
2 Jun 2010 à 17:37
Basically yes, but also that these worksheets are created from the original 'contents page' .
Is this possible?
Thanks.
2 Jun 2010 à 17:57
2 Jun 2010 à 18:04
Its a 2 part question really.
Firstly, and the main thing is I have is a list of 100+ error codes. I would like to create a worksheet for each of these error codes.
Secondly, from the list of 100+ error codes if a click on 1 cell it would take me to the created worksheet.
Thanks again.