View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave O
 
Posts: n/a
Default Linking incremental cells from another worksheet

Assuming your formulas are located in F2, F7, and F12: highlight and
copy F2:F12. Paste this into F17, which will provide formulas for F22
and F27. Highlight and copy F2:F27 and paste into F32. Highlight and
copy F2:F57 and paste into F62 and so forth. It's tedious but will
only take a few minutes since the range is doubling each time.