dynamically update photos in excel

  • Thread starter Thread starter cmotes
  • Start date Start date
C

cmotes

I'm using Excel to generate invoices. I have an invoice template that
uses a distinct item number to lookup basic info on the item, and show
it on the invoice (using vlookups). Easy. One of the items being
looked up is a photo URL for the item (example:
http://farm4.static.flickr.com/3133/pictureid.jpg) which I need to
display on each invoice.

I generate new invoices by updating the item number. I'd like the
invoice template to automatically update the picture of the item when
I update the item number. Today I have to manually embed the photos
via Insert->Picture and then copying in the photo URL.

Put another way, when item number changes, Excel runs a bunch of
vlookups to grab item data including a new photo URL... I want that
photo to actually update on the invoice template automatically.

Ideas?
 
Back
Top