Linking value of cell on one worksheet to a column on another work
 

I have a spreadsheet where I have two worksheets. On the first worksheet
(intended to be an index sheet), I have a list of numbers (about 30) and
text. On the other worksheet (my "data" worksheet), I have 30 columns of
information, each correlating to one of the numbers on the index worksheet.

I know about hyperlink, but that only links the index page value to another
worksheet. I don't want to create 30 different worksheets to use hyperlink;
my current spreadsheet only has 2 worksheets.

Is there any way to create a link from the index worksheet to a specific
column on the other worksheet, and view the contents on the data worksheet?
The data on the index sheet is not verbatim the data on the other sheet; i.e.
the index sheet might contain a model number, the data sheet might contain
the part number for the model.

Thanks much,

Dave

Linking value of cell on one worksheet to a column on another work
 

Hi

I'm not sure i fully understand. You want a hyperlink from Sheet 1 "jumping"
over to the specific cell in Sheet 2 ?

If that is so then you can right the specific cell in Sheet 1 and create a
Hyperlink. Press <Place in This Document and in <Cell Reference select
Sheet 2.
And at <Type the cell reference, type the cell reference.

Hope it helps

Chris



--
Christoffer Bloch Andersen
Trainee
NNE Pharmaplan A/S


"Dave" wrote:

I have a spreadsheet where I have two worksheets. On the first worksheet
(intended to be an index sheet), I have a list of numbers (about 30) and
text. On the other worksheet (my "data" worksheet), I have 30 columns of
information, each correlating to one of the numbers on the index worksheet.

I know about hyperlink, but that only links the index page value to another
worksheet. I don't want to create 30 different worksheets to use hyperlink;
my current spreadsheet only has 2 worksheets.

Is there any way to create a link from the index worksheet to a specific
column on the other worksheet, and view the contents on the data worksheet?
The data on the index sheet is not verbatim the data on the other sheet; i.e.
the index sheet might contain a model number, the data sheet might contain
the part number for the model.

Thanks much,

Dave