hyperlink between cells

Hello,
I have a series of cells with a hyperlink to another sheet

Please Login or Register  to view this content.

Please Login or Register  to view this content.

If I drag in down it does not connect exactly as the example.
I tried it with a formula for lines even / odd: = MOD (ROW (), 2)
to select only odd / even and then drag it down wrong.
There is an option in Excel to do this?
I hope I was clear
A greeting and thanks.

Try

=IF(INDIRECT("'articolo'!A" & INT((ROW()-1)/2)+2)<>0,INDIRECT("'articolo'!A" & INT((ROW()-1)/2)+2),"")
=IF(INDIRECT("'Descrizione'!C" & INT((ROW()-1)/2)+2)<>0,INDIRECT("'Descrizione'!C" & INT((ROW()-1)/2)+2),"")

confused by row 5 "missing" ???

drag down as a pair

Hello John Topley,
the formulas are o.k.
-------------------------
Ciao johntopley,
le formule sono o.k.


The formulas in Italian

Please Login or Register  to view this content.

thank you very much.
A greeting.
max_max
--------------------
ti ringrazio tantissimo.
Un saluto.
max_max

Information: the formulas work on Excel 2003?
max_max
------------------------------------------------
Informazione: le formule funzionano su excel 2003?
max_max