Auto updating formulas

[Budman36]

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 auto update the "101" section of the code to 102, 103, 104, etc. without typing them all out?

[#2]

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

[#3]

@Budman36 

If your hyperlink starts in A2, and you want to avoid a helper column, you may instead try this formula, copied down rows: 

=HYPERLINK("C:\Users\Documents\Folder "&ROW()-2+101,

Name)

The "2"in the foregoing pertains to the starting row of the formula, which is A2. 

[#4]

Hey @PReagan,

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

B