I have a macro that creates links to all the files (they are only pictures) that are in a specific folder.
Now however, I was wondering if there was a function that can relocate those hyperlinks (1 cell = 1 hyperlink) to the right area (they are all in Column A currently).
All the hyperlinks have 2 words and the file extension in it: the pole number, and an "id" or an "est" ending in it. Ex: 1784371E id.jpg and 1784371E est.jpg
Column "K" has the "id" pictures.
Column "J" has the "est" pictures.
Rows C5 - C50 contain all the different pole numbers.
See picture below to see how:
1. The links in column A look like once the macro makes the links
2. Column L is supposed to look once it is populated by moving over the links from Column A.
What function formula can I use to relocate the links on Column A to their needed spots?
Bookmarks