Adding additional fomulas to existing links from multiple sources

  • Hello, I’m trying to find a quick and easy way to multiply existing formulas/links to another cell

    I currently have a spreadsheet with approximately 300 rows, each row has a link to another workbook – 300 in total. Each workbook contains weights for specific structures. However I have to multiply the weight of each by a new quantity.

    Current formula “=G:\Estimate\[Anchor Pile Esimate.xlsx]summary'!$F$29”

    What I’m hoping to achieve without having to manually change each formula.
    “=(G:\Estimate\[Anchor Pile Esimate.xlsx]summary'!$F$29)*$H5”

    Each cell on my master spreadsheet has a link to a different spread sheet. I just want to change the current link to multiply by a value in column “H”. I’m not allowed to paste values then multiply the formula must show the link.

  • Re: Adding additional fomulas to existing links from multiple sources


    Cant you just use a helper column and use =A2*$H5
    where A2 is the cell containing that formula

    Regards


    Ford

  • Re: Adding additional fomulas to existing links from multiple sources


    If everything is going to be multiplied by cell H5 then you can...


    Go to Home > Find and Select > Replace > ReplaceTab > Expand options


    Find What: ='G:\
    Replace with: =$H5*'G:\


    Replace All

    One idiot throws a stone in the well, and it takes a hundred wise men to get it out.