software

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.

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,quot;Sheet2quot;))

as an example.

--
Regards,
Tom Ogilvyquot;mhutch71quot; wrote:

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