Thread: How do I copy formulas down a sheet using increments?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
LINDA LINDA is offline
external usenet poster
  
Posts: 205
Default How do I copy formulas down a sheet using increments?
I would like to be able to copy a formula down a column in increments of 7.
For example in cell A19 of sheet 2 the formula is: =+'sheet1'!A10. In cell
A20 of sheet 2 I would like it to be: =+'sheet1'!A17 and in cell A21 of sheet
2 I would like it to be: =+'sheet1'!A24 etc. etc. I don't want to have to
do it all manually if I can avoid it!

Thanks.
Reply With QuoteReply With Quote