I have a macro that creates a link for every file (specifically those files are only pictures-jpeg), and sets those links in Column A. If I have 110 jpegs in that folder, it will create 110 links all on Row A.
Those pictures have a specific naming system where... depending on what they are called, they belong to a specific column and row. There are about 45 different widgets, and each widget is named by numbers, and each widget has 2 pictures (for the most part) one ending in "est" and one ending in "id".
One column has the "est" pictures, and the other has the "id" pictures. The first 45-48 rows are for the corresponding widget number. How can I change the vba coding so that... when the link is created, it NOT ONLY puts the links that end in "est" and "id" in the correct columns, but also the right widget number in the right row?
I have uploaded the file so you guys can see...
1) Where the macro places the links (in row A)
2) Where those links are SUPPOSED TO BE in columns K & L, and the corresponding rows in column C.
Any help would be greatly appreciated.
Thanks
Bookmarks