Is there a way to copy a formula in a column without changing all the
cell numbers?

Example: =IF(C1=C2, A1,0)

How would I copy that down a colmn and only change the A1 to A2, A3, A4
and so on down the column?

Assisance appreciated !
Travelersway


--
travelersway
------------------------------------------------------------------------
travelersway's Profile: http://www.excelforum.com/member.php...o&userid=17623
View this thread: http://www.excelforum.com/showthread...hreadid=401681