Need Help With Copying Relative Formula

Try this anywhere in your Summary Sheet:

=INDEX('Data Input'!$A$1:$Z$100,COLUMNS($A:A),3*ROWS($1:2)-4)

Copy across and down as needed.

Adjust your indexed range as necessary.
--
HTH,

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


"Kia" <[email protected]> wrote in message
news:[email protected]...
>
> ello and thanks in advance to anyone who can point me in the right
> direction.
> I am running Excel 2003 on a Windows 2000 machine.
>
>
> I have 2 sheets in one workbook.
> sheet 1 is data input
> sheet 2 is summary
>
> I want to put this into summary
>
> .....A...........................B..........................C
>
> 1...='data input'B1........='data input'B2......='data input'B3
>
> 2....='data input'E1.......='data input'E2.......='data input'E3
>
> I have about 100 rows each of about 10 columns that I wish to do this
> with.
> I know I can do it the long way by hand but there must ba a shortcut I
> can use.
>
> I have tried coppying and pasting etc but I then get b1,b2,b3 going
> DOWN which I do not want.
> Each row of summary needs to increment the reference to 'data input' by
> 3 columns ie B,E,H,K
>
> Can this be done? How should I begin?
>
>
> --
> Kia
> ------------------------------------------------------------------------
> Kia's Profile:
http://www.excelforum.com/member.php...o&userid=30090
> View this thread: http://www.excelforum.com/showthread...hreadid=497754
>