VBA to enter formulas

[Javi]

Hi All

I have a workbook with 20 formulas (See below) all are referencing a different sheet (Sheet1 “MAIN”).
I need to create additional sheets with the same formula in each the same cell location. The one exception is the formula needs to reference the next row from the reference sheet (Sheet1 “MAIN”).

Thank you, any assistance would be greatly appreciated or even a different approach this is my third approach to this process.

The below formulas are located on (Sheet9) this sheet is completed.


(“C8”) =+Main!C10
(“A10”) =+Main!AK10
("K8") =+Main!J10
("C13") =+Main!C10
("C14") =+Main!F10
("C15") =+Main!AF10
("F15") =+Main!I10
("C17") =+Main!D10
("C24") =+Main!C10
("C25") =+Main!AF10
("C26") =+Main!D10
("C28") =+Main!E10
("F25") =+Main!I10
("I25") =+Main!J10
("C40") =+Main!C10
("C41") =+Main!AF10
("C42") =+Main!D10
("C44") =+Main!E10
("F41") =+Main!I10
("I41") =+Main!$J$10

Below is what I need be entered on (Sheet10). I will need to duplicate this process from (Sheet10 – Sheet59). (Sheet59 should eventually reference row 60)

(“C8”) =+Main!C11
(“A10”) =+Main!AK11
("K8") =+Main!J11
("C13") =+Main!C11
("C14") =+Main!F11
("C15") =+Main!AF11
("F15") =+Main!I11
("C17") =+Main!D11
("C24") =+Main!C11
("C25") =+Main!AF11
("C26") =+Main!D11
("C28") =+Main!E11
("F25") =+Main!I11
("I25") =+Main!J11
("C40") =+Main!C11
("C41") =+Main!AF11
("C42") =+Main!D11
("C44") =+Main!E11
("F41") =+Main!I11
("I41") =+Main!$J$11

 

[Fluff]

Duplicate Copy worksheet and create 60 sheets "manage formulas"

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).