Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Matching Picture to Reference
Hi I've been using Excel a good few years now, but never in great depth. I'm not sure how to sort through some data I have. Basically I'm setting up an Excel sheet to list all the products we sell (so far 27,000), I have images to go with these products. I'm trying to enter the image filename along side the product. All the images are named with the part number, which is in the excel sheet. It's easy enough to create the file name, I just Concatenate the Product Ref with a field with the contents of '.jpg'. However, not all of the products have an image to go with it, in this case I need to leave the field blank. I know there are programs available to download which can give you a list of the contents of a directory in Excel format, but this doesn't come in the same order as the 27000 products that I have in the Worksheet. So I'm left with the problem of having to sift through 27000 lines of data, checking that each one has an image to go with it. Basically, what I'm asking is is there a simpler way of doing this? I hope this makes sense, and that someone is able to help. Many thanks in advance Scott -- egattocs ------------------------------------------------------------------------ egattocs's Profile: http://www.excelforum.com/member.php...o&userid=35412 View this thread: http://www.excelforum.com/showthread...hreadid=551815 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Matching Picture to Reference
http://www.excelforum.com/showthread.php?t=480860 Was an answer given to me, which works and also inserts the picture by the side of the name (maybe a bonus!) I can take no credit for the macro as Dave Peterson Wrote it for me Hope it helps Regards Dav -- Dav ------------------------------------------------------------------------ Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107 View this thread: http://www.excelforum.com/showthread...hreadid=551815 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Matching Picture to Reference
Hi Dav Thanks very much for this. I will try it out! Thanks again Scott -- egattocs ------------------------------------------------------------------------ egattocs's Profile: http://www.excelforum.com/member.php...o&userid=35412 View this thread: http://www.excelforum.com/showthread...hreadid=551815 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert Picture from dropdown selection | New Users to Excel | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
How do you reference a picture to a cell? | Excel Discussion (Misc queries) | |||
Finding the cell reference of a matching search value | Excel Worksheet Functions | |||
How can you reference a picture from a worksheet cell? | Excel Discussion (Misc queries) |