One way ..
Put this in the starting cell, say, in B2:
=INDIRECT("'salary'!G"&ROW(A1)*4)
B2 returns the same as: =salary!G4
Just copy B2 down as far as required* to return the desired:
salary!g4
salary!g8
salary!g12
salary!g16
....
*down to B2001 thereabouts, since you have 8000 cells ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Daiv" wrote:
I am trying to refference specific cells from one worksheet to another. The
information I need is not in consecutive cells, they are, for example, 4
cells apart.
My problem is I have over 8000 cells that need filling and I am not about to
do that by hand :) When I put a few entries in then try to have the pattern
propogate it doesn't work. instead it backtracks. for example, if I entered
4 cells:
salary!g4
salary!g8
salary!g12
salary!g16
when i try to propogate i get a patern like:
salary!g8
salary!g12
salary!g16
salary!g20
salary!g12
salary!g16
salary!g20
salary!g24
How do i make the pattern consistant over the 8000 cells?