fill cells with even increment rows from a different worksheet

[Guest]

Hi,

Could anyone give me a formula to import data from A1, A13, A25 etc at 12
row increment in sheet 2 to B1, B2, B3 etc in sheet 1?

Thanks
FormulaChallenged

 

[RagDyer]

Try this:

=INDEX(Sheet2!A:A,12*ROWS($1:1)-11)

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

 

[Guest]

Thank, HTH. That works great!

Try this:

=INDEX(Sheet2!A:A,12*ROWS($1:1)-11)

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

 

[Gord Dibben]

=OFFSET('Sheet2'!$A$1,12*ROW()-12,0)

Entered in Sheet1 B1 and dragged down.


Gord Dibben Excel MVP

 

[Ragdyer]

Thanks for the feed-back.

BTW (by the way)

HTH stands for
"hope this helps"