fill cells with even increment rows from a different worksheet

[FormulaChallenged]

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!
==============================================


"FormulaChallenged" <FormulaChallenged@discussions.microsoft.com> wrote in
message news:D1178F3F-B41D-4D68-A75A-3508C5DEEFA9@microsoft.com...
> 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

[FormulaChallenged]

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" <FormulaChallenged@discussions.microsoft.com> wrote in
> message news:D1178F3F-B41D-4D68-A75A-3508C5DEEFA9@microsoft.com...
> > 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
>
>

[Gord Dibben]

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

Entered in Sheet1 B1 and dragged down.


Gord Dibben Excel MVP


On Wed, 7 Dec 2005 10:11:02 -0800, "FormulaChallenged"
<FormulaChallenged@discussions.microsoft.com> wrote:

>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]

Thanks for the feed-back.

BTW (by the way)

HTH stands for
"hope this helps"
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"FormulaChallenged" <FormulaChallenged@discussions.microsoft.com> wrote in
message news:E7CBEAB8-B83C-46F0-A549-9ABC0118EFB4@microsoft.com...
> 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" <FormulaChallenged@discussions.microsoft.com> wrote
>> in
>> message news:D1178F3F-B41D-4D68-A75A-3508C5DEEFA9@microsoft.com...
>> > 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
>>
>>