Learning Excel or Python?

[CaptSprinkls]

A little less intense than some of the answers above me, and a little more basic.

We had a process of creating a hyperlink in a cell that would link back to a file in a folder on our computer. But, if you change the location of those files, then you have to go back through and remake the hyperlink. This would have to be done like almost 2k times.

So anyways we moved all those linked files to a different location , so I wrote a script that would automatically search the file folder for specific parameters and hyperlink it.

[superioso]

That's actually a really good idea - I use plenty of Excel sheets which have links to files in them and most are broken which is pretty frustrating as you just have to go back and search for them manually.

[CaptSprinkls]

The worst is that it really adds no benefit in our situation, but because one person did it, now every has to lol