S
SpringStar
Hi folks,
I have created an Excel spreadsheet that contains product data such as
price, weight, case dimensions, UPC, etc... The sheet uses the VLOOKUP
function, which makes reference to cells in a separate tab to display the
product data in a "one-up view". The user simply selects the product name
from a pop-up list at the top of the page and all of the appropriate data
for that product is displayed below it. This one-up view makes an excellent
sell sheet for our Sales Reps to use when making a presentation, but what
they would really like is to have the a product photo diplayed on the page
as well.
I have a separate tab on the spreadsheet that allows the user to click on a
hyperlink to view a photo, but the image is displayed in the user's default
imaging program, not in Excel. What I really need for the image to appear
dynamically on the same 1-page "sell sheet" along with the data when the
user selects a specific product from the pop-up list.
I know I could accomplish this using a database program like FileMaker Pro,
but we prefer to use Excel because just about everyone on the planet has
Excel, but not everyone has a database program.
Any ideas on how to accomplish this?
B. Hanser
SpringStar LLC
I have created an Excel spreadsheet that contains product data such as
price, weight, case dimensions, UPC, etc... The sheet uses the VLOOKUP
function, which makes reference to cells in a separate tab to display the
product data in a "one-up view". The user simply selects the product name
from a pop-up list at the top of the page and all of the appropriate data
for that product is displayed below it. This one-up view makes an excellent
sell sheet for our Sales Reps to use when making a presentation, but what
they would really like is to have the a product photo diplayed on the page
as well.
I have a separate tab on the spreadsheet that allows the user to click on a
hyperlink to view a photo, but the image is displayed in the user's default
imaging program, not in Excel. What I really need for the image to appear
dynamically on the same 1-page "sell sheet" along with the data when the
user selects a specific product from the pop-up list.
I know I could accomplish this using a database program like FileMaker Pro,
but we prefer to use Excel because just about everyone on the planet has
Excel, but not everyone has a database program.
Any ideas on how to accomplish this?
B. Hanser
SpringStar LLC