Excel Tutorial : How to Display Images Dynamically based on Specific Cell Contents

preview_player
Показать описание
Рекомендации по теме
Комментарии
Автор

You are a genius! All the other examples referred to scroll list. You saved my life. TKS!

JhoanRusso
Автор

is there a way to create the formula so you can essentially drag down instead of creating the 4 different names?

alexb
Автор

Thank you. I followed you very well with my earphones. Result is very good.

bestvideoforcats
Автор

Awesome! You just earned a subscriber! I've been trying to figure out a non-VBA to accomplish this for years now!

travisanderson
Автор

GREAT VIDEO! Can't believe this is so easy now that You Have Shown Me How! I added a data validation list since I am going to be using a lot of images.

donaldblaess
Автор

Excellent work.  Guided me step by step into creating what no other site could show me how to do.  Cheers.

jednb
Автор

Great tutorial. Very neatly presented and addresses the purpose. Thanks for the post.

heyjaga
Автор

Thank you for the instruction! Now it's my turn!

michaelthomas
Автор

hats off. Brilliant. I have done a big excel with 70 pic. thanks a lot.

CarbonScode
Автор

THANK YOU SO MUCH, I WAS LOOKING FOR THIS TRICK FOR A LONG TIME

nelnar
Автор

Coyld you plase give me a resolution to th " reference is not valid" message error each time i try to name the special copied picture with the created name.

mahdjoubsofiane
Автор

can you do a tutorial on how to link the inserted image in different worksheet? then if you change the inserted image, all the images with the same image that linked to the inserted image will also change in different worksheet at the same time.

MRB_TV
Автор

Thanks a lot for the hint for copying a cell with the linked picture.

imyun
Автор

This is excellent (even works in Excel 2003) thank you very much. The only issue I have found is that when the workbook I created is opened in Excel 2013 any cell comments I have made only appear for a fraction of a second. Can this be solved at all without turning the comments on permanently?

benjamin_newton
Автор

Tks a lot this is amazing! I was find this solution! ;-) From Brazil.

rjsfrajola
Автор

Got error "Reference not valid" when I enter Flag1 in formula for the image (cell H2)

prithvirajc.m
Автор

Thanks very much I really appreciate the tutorial. I've used it to create a nice NBA template.

leekitchen
Автор

nice thought; couldn't see or hear what functions were being performed because I couldn't follow the cursor or what hot-key was used (e.g. how reference "flag1" was used, indirect function, etc.). Good idea, execution could have been more clear. thanks for the tutorial.

rmeveva
Автор

Amazing! Thank you so much for making this - used it along with wunderground.com API to create a weather forecast dashboard in Excel where the icons now update accordingly! Thanks again

LetsGoFly
Автор

thanks a lot .
I have an issue, if I need to extend thsese fixed rows from 4 to unlimited ( I mean implemating this image dynamic fetching for a recordset, or table or dynamic rows counts not for 1 or 4 row ), how can I do that ? Is there a solution ?

abcdpqzm
join shbcf.ru