Hi guys, hope everyone is keeping well.
I was wondering if I could get some help creating a macro which will insert images for me from a list.
I'm on Excel 365 for business. I have a list of unique codes descending in column A (100 row max) and then in column B I would like an image to be added which corresponds to that code, ideally to fit in a 100x25 box. The images are all located in a single folder and titled the same as their unique code. Images are also all jpegs.
Could anyone please offer any advice on how best to approach this? I'd be extremely grateful as currently I'm doing it manually which is very time consuming when working through multiple lists each day.
Thanks.
I was wondering if I could get some help creating a macro which will insert images for me from a list.
I'm on Excel 365 for business. I have a list of unique codes descending in column A (100 row max) and then in column B I would like an image to be added which corresponds to that code, ideally to fit in a 100x25 box. The images are all located in a single folder and titled the same as their unique code. Images are also all jpegs.
Could anyone please offer any advice on how best to approach this? I'd be extremely grateful as currently I'm doing it manually which is very time consuming when working through multiple lists each day.
Thanks.