repeat a formula same column same number of rows apart

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

steveo

Hi, I have a column where I need to repeat the same formula a set
number of rows apart. Is there a simple way to do this? The cell
references are relative and it would be nice if I could make this
formula repeat in several worksheets, yeah same places and same column
in each worksheet. (L). While the L column ends in different rows in
each worksheet, not necessarily at the bottom of the column. The
formula to be copied references data in the d column so when I run out
of data in the d column in each sheet can it repeat to the next
worksheet? Also the k column has a label of text for the result of that
formula. This is excel 2004 Mac. Any Ideas? steveo
 
Maybe you could group your sheets together before you write the
formulas then all the sheets would have the same formula
 
damorrison said:
Maybe you could group your sheets together before you write the
formulas then all the sheets would have the same formula
Click to expand...

damorrison, they are grouped together in a workbook although some data
and formulas are not common. And of course excel is not my favorite
thing. Any ideas on how to make the formula repeat a set number of
rows apart? Anybody? steveo
 

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 1
macro to repeat a formula a set number of rows apart 1
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Look for value that is six columns apart 2
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Repeating formulas.... 2
Fill formula down for cells 74 rows apart 3
Excel Help to copy information from one row at a time to another sheet 1

Back
Top