*this is same project as 1235385996, but winning bid is in lack of communication (total silence now) and did not manage to do the job within the timeschedule.
So if you do not have any experience with correct sorting of images in excel, do not bid.

Hi,

I have an excel-file (.xls) and in this file a spreadsheet with about 30 columns and around 500 lines.

The need is to import some fields from that first sheet into a second sheet PLUS the actual image from a directory.
So the image must be embedded into a excel cell, the information where to find the image is in the first sheet (directory and name of image). Make sure the image will be at the correct place when the sheet is sorted.

example:
SHEET1:
PRODUCTID NAME IMAGE SOLD
123456 PRODUCT1 D:\IMG\123.GIF YES


OUTPUT SHEET:
<IMAGE IN CELL> 123456 PRODUCT1 YES

MAX 15$ programming in vba excel