adding formulas from base formula sheet

[ammartino44]

Hello. I have 50 tabs in my workbook. To create them, I have a loop. They are all formatted the same. I want to select a specific range (which I know how to range) in all of the tabs and copy in the formula below. This is in the first column of the range, column C. Most of the values are hard coded, and refer to a master sheet.


=SUMIFS(Master!$D$2:$D$5,Master!$C$2:$C$5,'101'!$B2,Master!$B$2:$B$5,'101'!C$1)

[skywriter]

Range(yourrange).Formula = "=SUMIFS(Master!$D$2:$D$5,Master!$C$2:$C$5,'101'!$B2,Master!$B$2:$B$5,'101'!C$1)"

[ammartino44]

Boom boom pow. Let me get thaaaaat.

[skywriter]

Thanks for the rep. points.