Forum Discussion

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

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

Brass Contributor

Jul 23, 2019

Hey PReagan,

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