Thank, HTH. That works great!

"RagDyer" wrote:

Try this:

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

--
HTH,

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


"FormulaChallenged" wrote in
message ...
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