Hi all,
Thanks in advance for help.
I am trying to help my sister create a mailing list containing names and images which she changes constantly. The list involves 3 data fields (a name, a size, a price), plus a picture. In the sheet attached the sheet (Flower-Letter) will get PDFed and sent out. What I would like to do is have the code look for the Name (currently a, b, c , d, e etc) and then place the image of the relevant flower found on the sheet "Flowers - List" in the cell 4 rows below (formatted to fit it)
The Flowers-Letter page is fed from the input sheet where in cells F6-F43 the user will update the list of relevant items for that newsletter (these will also be pulled from the list to ensure they are exact matches). These are then put into alphabetical order and fed onto the Letter sheet. So would need to code to go through the names shown on the Letter Sheet (B4, D4, B10, D10 etc) and check each image corresponds (or if easier deletes all images minus logo at top and adds new relevant ones). Ideally images would be aligned to top left of their prospective cell too (the images will all be put into list exactly the same size and ratio). There will eventually be 4 from pages / lists but if I can get one working with help I should be able to modify code across the rest.
Not sure if this is possible - there is a link below to a thread that is similar but could not get it to work:
https://www.excelforum.com/excel-pro...ys-method.html
Have also looked at the linked image option but would require 100s of named ranges as far as I can understand.
Any advice would be much appreciated.
Thanks,
Alex
Bookmarks