copy formulas

[Guest]

I want to copy a formula from one cell and paste it into another cell that is
3 cells below the orginal cell copied. I need to do this several times, down
a worksheet. In the orginal cell I have a formula that pulls data from
another worksheet. What I need to be able to do is when I paste the formula
in to the new cell that it will increase the ref number by one, right now
when I paste it changes the ref number by 3 because I am moving down three
cells, but I want it to only change by one number.

 

[Guest]

redesign the formula to use the indirect function and calculate the row you
want the value returned from.

for example, on a blank worksheet, enter this in A1
=TRUNC((ROW()-1)/3)+1
then select A1 and drag fill it down the column.

as you see, it changes value every 3rd cell. Row() refers to the row number
of the cell containing the formula. So you could adjust this to give you the
proper reference

=Indirect(Address(TRUNC((ROW()-1)/3)+1,3,true,true,"Sheet2"))

as an example.