Copying Cells with Fill Handle
If you want "the number" to advance as you copy across, then don't put a $
in front of it, as in:
=$A1*2
Regards,
Fred
"RRG" wrote in message
...
Can anyone help? I am trying to copy cells across a row using the fill
handle
that are referencing another sheet down a column. I am placing a "$" in
front
of the letter as to not change it, but since I am copying across, the
number
will not change. Is there any way to tell Excel that i want the number to
advance as I copy across?
|