1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

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