The easy way is to grab the fill handle (lower right corner of source cell)
and drag down.

--
Don Guillett
SalesAid Software

"cardingtr" wrote
in message ...

Let's say I have a long formula I don't want to rewrite on each cell.
I want to paste it to other cells but also the formula should change to
reflect its new location.

Heres the formula:
=(B3="mild")*1+(B3="moderate")*2+(B3="mod-severe")*3+(B3="severe")*4+(B3="intolerable")*5

The above formula is in C3 referring to B3.

I want to paste it down starting in C4 but how will the fomula
automatically change from B3 to B4, B5, B6.....without typing it
manually?

Thanks.


--
cardingtr
------------------------------------------------------------------------
cardingtr's Profile:
http://www.excelforum.com/member.php...o&userid=27027
View this thread: http://www.excelforum.com/showthread...hreadid=514167