Create worksheets with links from a list

Closed
lewis_james_price - Jun 1, 2010 at 11:56 PM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
- Jun 2, 2010 at 06:08 PM
Hello I have a list in excel and for each entry in the list I would like to create a new worksheet with a link from the original list. Is this possible and how may worksheets are possible?

Hope you can help!

Lewis

1 reply

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Jun 2, 2010 at 10:36 AM
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.
0
lewis_james_price
Jun 2, 2010 at 05:15 PM
Hi,

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.
0
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Jun 2, 2010 at 05:20 PM
Are you basically saying that if you click on "Mr. Smith", it should take you to the sheet "Mr Smith" ?
0
lewis_james_price
Jun 2, 2010 at 05:37 PM
Hi,

Basically yes, but also that these worksheets are created from the original 'contents page' .

Is this possible?

Thanks.
0
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Jun 2, 2010 at 05:57 PM
Sorry still could not get my brains around creation part. What exactly you meant by created from original page. All i visualize is that you have clicked on a cell , and it takes you to sheet mr smith either existing or by creating one. I am sure I am missing some thing here
0
lewis_james_price
Jun 2, 2010 at 06:04 PM
Hi,

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.
0