Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
maintaining cell references
Does anyone have any ideas on how best to copy a relatively large range while maintaining the original cell references. The range to be copied is relative within each block, i.e. formulae can be copied from one cell to recreate the whole table - for this reason i wanted to avoid introducing dollar signs everywhere, although that in itself would be fairly time consuming. I'm also trying to avoid repeating data unnecessarily. Hopefully someone may have come across a similar problem. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
maintaining cell references
brzak - could you show a copy of the formula you're trying to copy and
the cells it will refer to (when copied across). You would need to use $'s but it's faster than you think. When you enter the original formula, as you put in each cell reference just press F4 to toggle the $'s and it would just depend on which way you want to copy your references how the $'s are applied. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
maintaining cell references
You can replace = with x=, then do the copy, then replace x= with =.
"brzak" wrote in message ... Does anyone have any ideas on how best to copy a relatively large range while maintaining the original cell references. The range to be copied is relative within each block, i.e. formulae can be copied from one cell to recreate the whole table - for this reason i wanted to avoid introducing dollar signs everywhere, although that in itself would be fairly time consuming. I'm also trying to avoid repeating data unnecessarily. Hopefully someone may have come across a similar problem. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel 2007 deleting columns and maintaining references | Excel Discussion (Misc queries) | |||
Maintaining Cell Format in Query | Excel Discussion (Misc queries) | |||
convert relative cell references to absolute cell references via amacro? | Excel Discussion (Misc queries) | |||
Maintaining Information in a Cell | Excel Programming | |||
Maintaining cell references when inserting cells elsewhere | Excel Discussion (Misc queries) |