thank you again for the time and attention youre giving me
youre understanding is 100% accurate
that is exactly what im trying to do
brock

"smw226 via OfficeKB.com" wrote:

Hi Brock,

Just to confirm my uderstanding:

Do you want, for example, the first hyperlink in sheet!A1 to reference Sheet2!
A1, then Sheet!A2 to reference Sheet2!A16 etc ?

Thanks,

Simon



BROCK8292 wrote:
thank you for your help smw226
the language you provided worked perfectly
so perfectly in fact that i was wondering if i might push my luck
my workbook contains two worksheets
worksheet 1 has 1600 rows of information
worksheet 2 has basically the same info but each row that contains that info
is now seperated by 15 lines thanx to you
is there a way to insert hyperlinks into column A of worksheet 1 that will
link each row to its corresponding row in worksheet 2?
any advice on this matter will be greatly appreciated and thank you for the
time youve already spent on me
brock

Hi BROCK:

[quoted text clipped - 55 lines]
thank you for your assistance
brock

--
--------------------
Simon - UK

Email at simon22mports [ a t ] hot mail [ d ot ]com

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200704/1