Insert a picture into named excel worksheets by client id vba

[DIMWIT]

Hi everyone,

I have a workbook containing multiple sheets. The first sheet contains a unique 4 digit id to identify the client. Other sheets within the workbook are named after a year group so Y1, Y2, Y3 and so on....

Elsewhere on my PC, i have files that are named with the 4 client digit id and year group and these files needs to be inserted as a picture in the corresponding sheet.

For example client id workbook for 2000. In year 1 worksheet i need to insert the 2000 Y1 picture, in the year 2 worksheet i need to insert the 2000 Y2 picture and so on. Not all clients will have picture files for every year group so if there is no image/file for say year 3 , i need it to ignore and go to year 4 and so on...

Does anyone has any code to help with this? The picture will also need to be cropped and resized once inserted into the worksheet.

Thanks in advance

 

[Rijnsent]

Hi DIMWIT,
I don't have that code a.t.m., but if you could post e.g. a recorded macro it's easier for people to help you.
Cheers,
Koen