Budman36Brass ContributorJul 22, 2019Auto 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 ...Show More
TwifooSilver ContributorJul 23, 2019Budman36 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.
