fill series

  • Thread starter Thread starter Kelly McFaul
  • Start date Start date
K

Kelly McFaul

I have a worksheet that has 8 columns and 105 rows. Each cell gets the data
from another sheet in the workbook.
I can't seem to be able to fill down the formula the way I need it.
The first row in the first column gets the data from 'Daily Data'!A8, the
second row would be 'Daily Data'!A18, third row 'Daily Data'!A28, and so
forth. So each row needs to skip down 10 rows to get the next value. How can
I do this by using fill series or the fill handles? I've tried both and
can't seem to get it to work.
I don't mind entering the formulae in the first couple of rows, but REALLY
don't want to have to enter the formula 840 times!
Thanks in advance for any advice.
Kelly
 
Instead of putting in the starting cell
say, in A2: ='Daily Data'!A8

Put in A2: =INDIRECT("'Daily Data'!A"&ROW(A1)*10-2)
[the functional equivalent of: ='Daily Data'!A8]

Now you can copy A2 down and it'll give the results wanted,
i.e. it'll return the functional equivalents of:

in A3: ='Daily Data'!A18
in A4: ='Daily Data'!A28
and so on
 
Back
Top