repeat a formula same column same number of rows apart

  • Thread starter Thread starter steveo
  • Start date Start date
S

steveo

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

repeat a formula same column same number of rows apart 2
macro to repeat a formula a set number of rows apart 1
Fill formula down for cells 74 rows apart 3
Find values across a row and return a text value from the same column 2
Repeating formulas.... 2
Sequential numbering when X column repeats records 3
Excel Drag autofill only part of formula 3
countif formula to find the occurances of a number that is greater than one number but less than ano 3

Back
Top