Keep cell reference when moving range (matter of urgency)
Appreciate the feed-back.
--
Regards,
RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------
"Xtian" wrote in message
...
Perfect! Thank you very much!
Ragdyer skrev:
In A10 enter this formula:
=INDIRECT("C"&ROWS($1:10))
And copy down as needed.
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Xtian" wrote in message
...
I have the following problem:
In the range C1:C20 i have some data. I the range A1:A20 i have this
"formula": In A10: =C10, in A11: =C11, and so on.
The problem is: I want to have the ability to cut for example the range
C17:C20 and paste it in the range C11:C14, WITHOUT changing the formulas
in
the range A1:A20. That means, I do still want the formula in A11 to be
=C11
(and not =#REF).
Thank you.
|