Forum Discussion

Budman36's avatar
Budman36
Brass Contributor
Jul 22, 2019

Auto updating formulas

Is it possible to have formulas auto populate.  Example would be a hyperlink.  Let's say the formula is =HYPERLINK("C:\Users\Documents\Folder 101",Name). I need to make like 300 of these.  How can I ...
Formulas and Functions
PReagan's avatar
PReagan
Bronze Contributor
Jul 22, 2019

Hello Budman36,

 

You could make a helper column in Column B with numbers 101, 102, 103, etc. listed and use this formula in cell A1:

 

=HYPERLINK("C:\USERS\DOCUMENTS\FOLDER " & B1 & ",Name")

 

Then simply copy the formula down to the last cell that contains a number in Column B.

 

Hope this helps!

PReagan

  • Budman36's avatar
    Budman36
    Brass Contributor
    Jul 23, 2019

    Hey PReagan,

    This worked perfect!  Thank you so much for your help.  You saved an extreme amount of frustration!

     

    B 

     

     

Resources