I am working with a spreadsheet with two tabs of 1,000 rows. I would like to
hyperlink from one to the other. I can install a hyperlink in row one, but
when I try to copy and paste for the next 999 rows, the link stays up on row
one instead of following down the the next rows.

Is there a way of propogating a hyperlink down the page without having to
enter manually enter it in each cell?

Don't

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Rooky228" wrote in message
...
I am working with a spreadsheet with two tabs of 1,000 rows. I would like
to
hyperlink from one to the other. I can install a hyperlink in row one,
but
when I try to copy and paste for the next 999 rows, the link stays up on
row
one instead of following down the the next rows.

Is there a way of propogating a hyperlink down the page without having to
enter manually enter it in each cell?

Don,
Why not?

"Don Guillett" wrote:

Don't

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Rooky228" wrote in message
...
I am working with a spreadsheet with two tabs of 1,000 rows. I would like
to
hyperlink from one to the other. I can install a hyperlink in row one,
but
when I try to copy and paste for the next 999 rows, the link stays up on
row
one instead of following down the the next rows.

Is there a way of propogating a hyperlink down the page without having to
enter manually enter it in each cell?

Use a Hyperlink formula in an adjacent column.
The following formula links to the cell in Column B of Sheet2 that is in the
same row as the hyperlink formula. The formula can be filled down or up.

=HYPERLINK("[TestBook.xls]Sheet2!B" & ROW(),"Click Me")
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"Rooky228"
wrote in message
I am working with a spreadsheet with two tabs of 1,000 rows. I would like to
hyperlink from one to the other. I can install a hyperlink in row one, but
when I try to copy and paste for the next 999 rows, the link stays up on row
one instead of following down the the next rows.

Is there a way of propogating a hyperlink down the page without having to
enter manually enter it in each cell?

Jim, thank you! Works great.

"Jim Cone" wrote:

Use a Hyperlink formula in an adjacent column.
The following formula links to the cell in Column B of Sheet2 that is in the
same row as the hyperlink formula. The formula can be filled down or up.

=HYPERLINK("[TestBook.xls]Sheet2!B" & ROW(),"Click Me")
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"Rooky228"
wrote in message
I am working with a spreadsheet with two tabs of 1,000 rows. I would like to
hyperlink from one to the other. I can install a hyperlink in row one, but
when I try to copy and paste for the next 999 rows, the link stays up on row
one instead of following down the the next rows.

Is there a way of propogating a hyperlink down the page without having to
enter manually enter it in each cell?