Automatic Hyperlink

[Gabe]

I have two sheets in a workbook and am tryin to condense
the first sheet onto the second sheet using hyperlinks to
link back to the first sheet. The data I am trying to
link is always three rows previous to the other entry.
In other words, I am trying to link as follows:
Sheet 2 to Sheet 1
Cell c4 EZ4
Cell c5 EW4
Cell c6 ET4
Is there a macro I can add in to do this automatically or
a formual I can put in to make this work?

 

[Frank Kabel]

Hi
enter the following in cell C4
=OFFSET('sheet1'!$EZ$4,0,(ROW()-4)*(-3))
and copy down

 

[Guest]

Frank,

Thanks that worked very well.

-----Original Message-----
Hi
enter the following in cell C4
=OFFSET('sheet1'!$EZ$4,0,(ROW()-4)*(-3))
and copy down

--
Regards
Frank Kabel
Frankfurt, Germany


.

 

[Guest]

One more question - How do I then change it to go ten
lines down in the same column?
Sheet2 to Sheet 1
c3 fc4
f3 fc14

 

[Frank Kabel]

Hi
enter the following in C3:
=OFFSET('sheet1'!$FC$4,(COLUMN()-3)*10,0)

Note: works if the next cell is D3 (and not F3)