Switch from this:
A1: =C1/B1


to this:
A1: =C1/B$1
Then copy that formula down.

(The dollar sign in a reference "locks in" that part of the
reference.)

Does that help?

Regards,
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=506024