I'm pretty green at Macros and only started messing around with them recently, tried googling and copying stuff others have posted but cant seem to figure out what i need.
I have URL images in column M, M2:M320. Not all cells have a URL some are blank.
In column N i have labels for the corresponding pictures.
I would like a macro/function/formula to read a cell in column M, if it has URL post to a second worksheet with the picture and Picture name close by/attached.
I would prefer all the images/names to print to the single second worksheet and simply start posting lower on the worksheet as needed.
If i can have a function built in to set the pic size to the pixels i want that would be awesome, else the actual picture size should be fine.
I plan to start studying/reading up on Macros/VBA but would love to get this working sooner than later for a project im doing at work. Any help would be greatly appreciated!!!
I took coding a couple years ago in school (its been a while though) and use basic excel weekly so i know enough to stumble around but by no means know what im doing :P
Bookmarks