Log In
Register
Home
Active Member
June 18, 2018
Offline
Hi, I'm not good with these things and I've tried looking online but I can't find anything that I can actually understand.
I have a folder on my PC containing images (jpgs). And I have an excel spreadsheet containing details of the items relating to those images. I regularly update the folder to add new images for the items already in the spreadsheet. I will also on occasion add items to the spreadsheet and add the images to the folder at a later date.
I would like to be able to use VLOOKUP to link that images folder with the image name to the corresponding item in the excel spreadsheet, and I would like the spreadsheet to update automatically each time I add a new image to that folder where there is a corresponding line in the spreadsheet.
There is a column in my spreadsheet that contains the exact name of the images without the extension. Basically, I want to see in the spreadsheet where I have images for the items and where I don't so that I can obtain images for those that don't. I only want the spreadsheet to show the name of the image file and not a direct link.
I hope i've explained it well enough so that you understand what i want. And i do hope you can help me figure this out. Thanks
VIP
Trusted Members
June 25, 2016
Offline
Hi Jon
You can refer the article below:
https://www.myonlinetraininghu.....-using-vba
Hope this helps.
Sunny
Active Member
June 18, 2018
Offline
Thank you.
However, all of that information is very confusing and I can't tell if it is exactly what I want because I don't know how to do it myself. I am not excel literate and I really need a dumbed down step-by-step of how to do this (including where i need to click ect).
You really have to approach me like i'm as thick as two bricks or I really wont understand :-/
VIP
Trusted Members
June 25, 2016
Offline
Try downloading the workbook.
The workbook contains only 1 button.
Click the button, select the required folder and click OK
It will create the necessary links for you.
Active Member
June 18, 2018
Offline
Ok, so i see how that part works.
What I'm trying to figure out now is how to pair the file names to the item list using a vlookup. Si i have column 'A' with the item numbers and i want column 'B' to be the link at the side. But not all item numbers have images. Is there any way for me to just click that button and the items that do have images will have the link appear right next to them? And will the links automatically appear where they need to each time a new image is added to the folder? Or will I have to click the button to repopulate the list in excel every time new images are added to the folder?
VIP
Trusted Members
June 25, 2016
Offline
Please attach an example of your expected result. Include notes if possible.
It will help us to understand what you really wanted.
Active Member
June 18, 2018
Offline
Image 1 is the list of product codes.
Image 2 is the list of linked images.
Each list is currently in a separate tab. I want to have all information in one tab.
I want to have a VLOOKUP down column 'B' of image 1 with a result explained in Image 3.
So i want to match my product code list to the image link list populated by the hyperlink button from the workbook I downloaded.
Each time I add a new image to the linked folder, I want the new image link to appear at the side of the corresponding existing product code.
Let me know if there's anything you need me to explain in further detail 🙂
VIP
Trusted Members
June 25, 2016
Offline
I have done some changes to Philip's file that you downloaded earlier.
The assumption is that your product codes are in column A.
The macro will create the link in column B (same sheet as your code) only if the product code image is found.
You will have to run the macro again if there are any addition of new images.
Hope this helps.
Sunny
1 Guest(s)
