| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do i copy a formula with different cell reference?
how do i, by copying a formula (with cell reference) 3 rows down but the cell
reference in the formula itself refers 20 rows down? i'm using office 2003. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how do i copy a formula with different cell reference?
If there is a calcuable pattern, then you design the formula to calculate
where it should reference using something like Offset and some math. If not, then copying the formula would not be practical. You would reconstruct it. -- Regards, Tom Ogilvy "wisonn" wrote in message ... how do i, by copying a formula (with cell reference) 3 rows down but the cell reference in the formula itself refers 20 rows down? i'm using office 2003. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy an exact formula without changing cell reference | Excel Worksheet Functions | |||
| Copy formula from one workbook to another without reference to 1st | Excel Discussion (Misc queries) | |||
| Copy formula down a column does not use correct cell reference | Excel Discussion (Misc queries) | |||
| Copy Cell or Column without advancing formula reference? | Excel Discussion (Misc queries) | |||
| HOW DO I COPY FORMULA WITHOUT CHANGING CELL REFERENCE | Excel Discussion (Misc queries) | |||
Linear Mode
