melmur2028
New Member
- Joined
- Nov 19, 2020
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
I am trying to build out a VBA code that leverages unique codes - this document needs to accomodate up to 500 unique codes
I have these unique codes running the length of rows 8, 30, 52, 74, 96, 118, 140 -- columns F to DA
id like to pull in specific images (whose file names match back to these codes) to populate the cell +2 directly above
i.e Unique code listed in Cell F8, looking to input image into cell F5, unique code listed in N30 looking to input image into cell N27 ETC
everything i have been able to find has only returned solutions using drop downs or index match
Alternatives only provide code to input an image directly to the right of the cell for one or 2 images only
Ideally i would also be able to apply the same macro to multiple sheets within my document
Appreciate any help or direction!!!!
I have these unique codes running the length of rows 8, 30, 52, 74, 96, 118, 140 -- columns F to DA
id like to pull in specific images (whose file names match back to these codes) to populate the cell +2 directly above
i.e Unique code listed in Cell F8, looking to input image into cell F5, unique code listed in N30 looking to input image into cell N27 ETC
everything i have been able to find has only returned solutions using drop downs or index match
Alternatives only provide code to input an image directly to the right of the cell for one or 2 images only
Ideally i would also be able to apply the same macro to multiple sheets within my document
Appreciate any help or direction!!!!
