Hi,
I am trying to create a spreadsheet for an online gift registry. They require that the spreadsheet have the photo's url's in a column. I already have the spreadsheet filled with my data. In the spreadsheet, Column D is filled with unique numbers, some with parenthesis, (ex. 52011, 52011(2), 34132, etc.) I also have a folder full of images that are similarly formatted as such
"...\images\brand_name_52011.jpg". (They will be moved eventually to a webserver.) Each number in the column may or may not have a corresponding image. And the images may or may not have a corresponding number in the spreadsheet. Is there a way to generate a url automatically in a column that corresponds to the image with the matching number? And if it doesn't, just leave it blank?
I found this and it seemed similar, but not the same.
http://www.excelforum.com/excel-misc...-url-list.html
I am completely new at this and don't know where to begin.
Thanks in advance,
Chris
Bookmarks