Hi June:

something like:

=HYPERLINK("#"&CELL("address",Sheet3!$Z100),"targe t")

if copied down will produce:

=HYPERLINK("#"&CELL("address",Sheet3!$Z100),"targe t")
=HYPERLINK("#"&CELL("address",Sheet3!$Z101),"targe t")
=HYPERLINK("#"&CELL("address",Sheet3!$Z102),"targe t")
=HYPERLINK("#"&CELL("address",Sheet3!$Z103),"targe t")

so the row reference adjusts automatically without editting
--
Gary''s Student - gsnu200730


"june.sidwell" wrote:

is it possible to create a hyperlink to another sheet in a workbook with an
absolute column and a relative row refrence? And can it be copied down a
column without having to edit it for each row?