Hi Mynda,
Lovely technique described in your video https://www.youtube.com/watch?v=mpOU5bsYmC4.
I got a bit stuck when trying to adapt it to an entire column of pictures:
- where I would like each picture (for example in cells, column B) to correspond to the value selected in column C on the same row.
- if Value in C is null then I would like no picture selected in correspondent cell, column B.
Name manager works nicely with absolute reference. But not sure how to copy and adapt the formula for the entire column B.
Many thanks for your help,
Oana
Hi Oana,
Can you please share your file so I can see what you've set up so far with the name manager, or at least a small sample file with your example?
Mynda
Hi Mynda,
Please find a sample file attached.
My original report has hundreds of lines and I am hoping to be able to use a a dynamic formula in Status Column.
Also, not entirely sure how this setup could work when adding a new line to the report, as a sample picture would need to be copied every time? Happy to use VBA if required.
I am currently using Excel 2016, O365 subscription not available yet unfortunately.
Very grateful for your time and your help,
Oana
Hi Oana,
Thanks for sharing your file. This isn't possible because references made from objects cannot be relative. You would have to create a separate SelectedPic named formula for every row, which while possible, is not desireable.
Perhaps you can use wingdings instead. See examples attached.
Mynda
Hi Mynda,
Many thanks for suggesting this alternative, great idea I will give it a go.
Have a good weekend,
Oana
