Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
repeat a formula same column same number of rows apart
Hey guys, does anyone have a formula to make a formula repeat itself in
the same column (L) the same number of rows apart and possibly jump to the other worksheets in a workbook? This is excel for mac 2004.I'd greatly appreciate your help. It would be nice if when data ran out in the d column which the original formula refers to the formula simply repeats in the same places in the other worksheets. The cell values are relative. steveo |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
repeat a formula same column same number of rows apart
hi,
formulas return a value, they can not perform an action such as repeat itself, jump to other worksheets, copy, paste, insert, ect. you would need a macro to perform actions like you discribe but without more info, i would be hesitant to suggest anything. Sorry. regards FSt1 "steveo" wrote: Hey guys, does anyone have a formula to make a formula repeat itself in the same column (L) the same number of rows apart and possibly jump to the other worksheets in a workbook? This is excel for mac 2004.I'd greatly appreciate your help. It would be nice if when data ran out in the d column which the original formula refers to the formula simply repeats in the same places in the other worksheets. The cell values are relative. steveo |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Format as a MACRO | Excel Worksheet Functions | |||
how can i multiply two columns | Excel Worksheet Functions | |||
Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
=SUMPRODUCT formula help | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |