VBA Code Need it to Copy Formulas

[rsrasc]

Hello all,

I have about 15 files that I have to manually copy & paste the following formula in Columns I, K, M, O, Q, S, U, W, Y, AA, AC & AE.

=IF(ISNA(VLOOKUP($C7,'FY 23 Actual + Reforecast'!$A$1:$AI$503,I$1,FALSE)),"$0.00",VLOOKUP($C7,'FY 23 Actual + Reforecast'!$A$1:$AI$503,I$1,FALSE))

The formula is to be copy right below the corresponding month (well, 12 of them), and is looking for the value associated or corresponding to what is in cell C7 (then C16, C27, C38 and so on) in this case. In the attachment you will see the formula highlighted in blue. Then I will copy the formula to cell I17, I28, and I39


With your help I would like to have a macro that will do this for me.

Please let me know if you have any questions or need additional information.

Thanks!
rsrasc