Auto updating formulas

Question

Is it possible to have formulas auto populate. &nbsp;Example would be a hyperlink. &nbsp;Let's say the formula is =HYPERLINK("C:\Users\Documents\Folder 101",Name). I need to make like 300 of these. &nbsp;How can I auto update the "101" section of the code to 102, 103, 104, etc. without typing them all out?

preagan · Answer

Hello&nbsp;Budman36,&nbsp;You could make a helper column in Column B with numbers 101, 102, 103, etc. listed and use this formula in cell A1:&nbsp;=HYPERLINK("C:\USERS\DOCUMENTS\FOLDER " &amp; B1 &amp; ",Name")&nbsp;Then simply copy the formula down to the last cell that contains a number in Column B.&nbsp;Hope this helps!PReagan

budman36 · Answer

Hey&nbsp;PReagan,This worked perfect! &nbsp;Thank you so much for your help. &nbsp;You saved an extreme amount of frustration!&nbsp;B&nbsp;&nbsp;&nbsp;

twifoo · Answer

Budman36&nbsp;If your hyperlink starts in A2, and you want to avoid a helper column, you may instead try this formula, copied down rows:&nbsp;=HYPERLINK("C:\Users\Documents\Folder "&amp;ROW()-2+101,Name)The "2"in the foregoing pertains to the starting row of the formula, which is A2.&nbsp;

Forum Discussion

Auto updating formulas

3 Replies

Resources