Data match with external image data

[ljwmis]

I have a data matching problem as follows;

I have an Excel 2003 spreadsheet containing the details of 1000 members of staff and a separate folder containing .jpg images of the same 1000 members of staff.

How can I match the details of a single department (e.g. 100 members of staff) against the 1000 .jpg images to either a) produce a combined spreadsheet holding the data and correct images or b) to have a departmental spreadsheet containing the 100 staff with a folder containing the 'matched' .jpg images.

The spreadsheet contains the employee number (e.g. 12345678) and the .jpg images are saved as '12345678.jpg' so there is a common identifier.

Thanks for the help!

 

[SkipVought]

Hi,

This appears to need a coded solution.

Please report in ...

VBA Visual Basic for Applications (Microsoft) Forum707

Skip,

_[red][/red]