Is there a script to import excel formulas to multiple workbook?
from:

My situation is:
1. I have 50 workbooks, each workbook contains data in the same format for that specific object.

2. I need to create formulas for each workbook on a separate sheet to derive statistic results.

3. Don't want to type in 50 times of same formulas for each workbook base on their object names. (eg. for workbook1 I will have SUM(Workbook1Sheet1!A1:A100), then for Workbook2 I need to do same but change to Workbook2Sheet1)

4. Is there a script or a way to import excel formulas and...

Is there a script to import excel formulas to multiple workbook?

Poster :
choyj