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

Discussion in 'Programming' started by choyj, Mar 20, 2014.

0
  1. #1
    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 it will able to detect the Sheet name and just work out the formula?

    Thanks!
     
    choyj, Mar 20, 2014 IP
  2. choyj

    choyj Member

    Messages:
    47
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    41
    #2
    I guess Find and Replace is the only way.

    Welcome any other solutions.

    Thanks!
     
    choyj, Mar 20, 2014 IP