Insert Images based on cell name before "-"

briguy123

New Member
Joined
Feb 1, 2021
Messages
1
Office Version
  1. 2019
Platform
  1. Windows
I currently have a macro that pulls a list of Part Numbers that needs to get done for the week. I would like to use another macro to add a picture beside the part number cell to give a little visual of the what the part looks like.

I already have a macro that does this but not how I want it... below is a list of why it isn't working.

Main Issues

-Picture files are not exactly named after the part number ex. ACTUAL PART NUMBER = 1234-01,1234-02 PICTURE FILE NAME = 1234
- jpeg and png files in it
-Some picture files are accurate to one but apply to many ex. ACTUAL PART NUMBER = 1234-01, 1234-02 PICTURE FILE NAME = 1234-01
^ For this example I want the 1234-01 to also apply to the 02.

I can send my code that I have right now but it is doing weird things like duplicating and I also had to add an abbreviated Part Number column to try and help.

Here is a picture of the formatting,
1612205447741.png


Thanks
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

Watch MrExcel Video

Forum statistics

Threads
1,130,169
Messages
5,640,550
Members
417,151
Latest member
ChickenTenderer

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top