|  | dynamically update photos in excel | | |
| | | Guest |  |
|  Posted: Sun Sep 21, 2008 5:58 pm Post subject: dynamically update photos in excel |  |
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:
LINK) 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? |
| |
| | | Gord Dibben | |
| | Posted: Sun Sep 21, 2008 7:34 pm Post subject: Re: dynamically update photos in excel | |
John McGimpsey's lookuppics should fo the trick.
LINK
Gord Dibben MS Excel MVP
On Sun, 21 Sep 2008 10:58:56 -0700 (PDT), cmotes@gmail.com wrote:
| Quote: | 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:
LINK) 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? |
|
| |
|
|
