Need Help With Copying Relative Formula

K

Kia

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?
 
R

RagDyer

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