I usually try to put the $ before dragging the cells, but when I want a copy
of the data somewhere that refers back, I to the first cell where I want the
data, enter "=" and click the first cell of the area where I want to copy
from. Then drag to expand to the whole area.

"GregP1962" wrote:


How do I copy formulas from a large group of cells to another group of
cells and have them all keep the references to the same cells? (It
normally changes the referneces to cells that have the same position in
relation to the former cell) I don't want to go in and change all of the
references, adding the $ sign.


--
GregP1962
------------------------------------------------------------------------
GregP1962's Profile: http://www.excelforum.com/member.php...o&userid=33063
View this thread: http://www.excelforum.com/showthread...hreadid=535102