Thank you Marcus and Max, your information was exactly what I needed to keep
me from having to manually edit almost 300 cells of formulas.


"Max" wrote in message
...
"Adam Kroger wrote:
.. 1: when copying and pasting formulas, is it possible to specify the
"step"
the formula references will take between cells? Example: A formula in
A1
references data in cell C1, when I copy the fomula to A2, I want the
reference to go to C3 (instead of C2).

One way

Taking your example process ..

Put in the starting cell, say A1: =INDIRECT("C"&ROW(A1)*2-1)
Copy A1 down

This would return the same as:

In A1: =C1
In A2: =C3
In A3: =C5
etc

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--