S
Steve
I have created a worksheet that will provide sales details for 30
different retail locations. I select the store number and then the
sheet poplulates with all the individual data from a database contained
in the workbook.
Now I would like to have a different photo displayed on the same sheet
that coorelates to that store. I have 30 JPEGs and haven't been able
to figure out how I can get the image to switch when I select a
different store.
Is this even possible. I know it can be done in Access but I am
attempting to keep this project in Excel.
The only other alternative I have is to create 30 different tabs (one
for every store) and put a different photo on each tab. Not a very
friendly alternative because changes would be a pain. This sheet
already has five graphs that dynamically update.
Can anyone help.
Steve
[email protected]
different retail locations. I select the store number and then the
sheet poplulates with all the individual data from a database contained
in the workbook.
Now I would like to have a different photo displayed on the same sheet
that coorelates to that store. I have 30 JPEGs and haven't been able
to figure out how I can get the image to switch when I select a
different store.
Is this even possible. I know it can be done in Access but I am
attempting to keep this project in Excel.
The only other alternative I have is to create 30 different tabs (one
for every store) and put a different photo on each tab. Not a very
friendly alternative because changes would be a pain. This sheet
already has five graphs that dynamically update.
Can anyone help.
Steve
[email protected]