Copy formulas with pattern

  • Any ideas on how i could copy formulas with a pattern, that differ from the target cell relation to the source cell?

    I have some arrays using index and match that would take a long time to do it manually.

    Please see attached file, sheet (Aug-2), cell range BC5:BM30, i need to repeat this pattern all the way down to cell BM394.

    i would prefer not to use volatile function, as there will be many sheets, and the program can run too slow.


  • Re: Copy formulas with pattern

    I don't think there is going to be a way without creating volatiles with OFFSET or INDIRECT. I would copy and paste blocks of formulae, and then run find and replace, changing, for instance, $D$6:$AY$6 to $D$11:$AY$11. Not a perfect solution, but not a completely manual one, either.

    Ali :)

    Enthusiastic self-taught user of MS Excel who's always learning!
    If anyone has helped you towards solving a problem, then you can thank them by clicking on the like icon bottom right.

    :!:Forum Rules

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!