View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Erin Dicks Erin Dicks is offline
external usenet poster
 
Posts: 8
Default Copying non-contiguous formulas

I want to copy down formulas refering to ranges of 25 rows (e.g. sum rows
1-25, sum rows 26-50 etc.) but when I copy the formula down, it only adds one
to each reference, not 25 (even when I've supplied several correct formulas).
Are there any tricks for getting around this? I have to copy the formula down
100 times and don't really want to type each one.