Excel Macro for hyperlink
$30-100 USD
Pago na entrega
I have Excel projects that require me to look at images in extensive databases that have image references in each data record. Now, I look at the image reference and then go to the sub-directory containing the images and manually find the image. The image reference is in the image file name.
I want a macro that I can start at the top of the image reference column and have it proceed through the entire database and have it automatically execute a hyperlink to the image. Because the subdirectory containing the images will change, I want to edit the macro to adjust the subdirectory to link. Also, sometimes the image is not present, so I do not want the macro to freeze if an image file cannot be found.
I want to have the ability to transfer the macro to different spreadsheets and projects. This should be easy.
## Deliverables
Attached is a sample file with images. The images are always in a different sub-directory, so plan accordingly.
ID do Projeto: #3677651