Видео

OMG...... All I want to do is put a word into a cell and in another cell a pic populate the cell. That is all that needs to happen but ooohhhhh no. I have been working at getting exactly what I just wrote for the past 4 hours...... I have gotten one cell with a drop down list to produce the pic in the other cell but I can not for the life of me figure out how to copy that drop down list to other cells and have those selections put in other pics. Having 1 cell only that can put 1 pic from a list of pics into 1 cell is worthless to me. I have 215 cells that have drop downs and those drop downs need to each produce a pic in the cell to the left of it and not have all the pics be the same. Excel can get aggrivating sometimes and this one is off the charts.

@alanjarvis1892 Dear Coach We hope this message finds you well. We are YAGI TEAM, and we recently had the pleasure of reviewing your course on Udemy. We were truly impressed by its quality and appeal, which we believe has significant potential for increased sales with the right promotional strategies. We would be delighted to discuss how we can assist you in elevating your course's profile and achieving the success it deserves. Best regards YAGI TEAM

Hi Alan, thanks for the excellent sharing. I am facing an issue, that is the name with '-', example Chan-Too-Hoo, then it doesn't worked. also if we input an invalid name, the 'previous image' still remain / display. this is causing some confusion. appreciate your adv. Thanks once again

Does the other workbook need to be opened before being called ?

How to put v lookup from folder to excel

Hi Alan. Your video was really helpful but I have a question. I set mine up with over 1000 photos of students and the last 30 photos on my list won’t change. I assume my data list is short but I don’t know how to fix it! Any advice?

I just met with reference isn't valid.

Thank you your video help me so much

Great

Süper

for people having ref errors, it appears it doesn't work with spaces in words

Thank you very much for this its very helpful very time saving

May i know what excel version you use ? Tq

Has anyone had issues with the pictures/picture of a cell being cropped strangely or shifting in the place you are using the indirect reference? For example, when you search Ashley here, maybe it only shows half her face and she's right justified instead of centered?

Thanks Alan!

Quite simple and explanatory. Weldone Alan and thank you for this!

how do you do it with columns

Hi Alan! How cool is this feature!!! My question though, I have my "mugshot" cell referencing a =vlookup cell and when the data changes in the vlookup cell the mugshot cell doesn't automatically change pictures until I click on the picture. Is there a way to make it automatically change when the data in the vlookup cell changes? (vlookup cell references a state based on how many miles driven - if they type in 700 miles, Kansas will pop up, if they type in 2400 miles, California will pop up etc)

this course is so useful, thank you very much sir. im gonna share this to my friends

Thanks a lot. Very helpful.

Hi Alan - Great video 👍👍 Would be possible to "built" upon the picture with further "pictures" into an all ready chosen picture ?

How can i copy this number. When i copy and paste another sheet show #value

thankyou for this video where you have explained very well how to return a pic in a cell by using name manager. issue is that it is technically working, but not instead of returning the pic, it is showing grey borders..something changes, but it's not the picture

This solved my 3 hour formula headache! Thanks Alan for the great video

THANKS SIR ,LEARN 100% FROM U

(still learning) I need help duplicating the information in another row. When I do, it changes all the images at same time.

Hello. great tutorial. everything worked right up to the end where I typed the name in that selected cell but the image disappeared.

I come here from skillshare... actully my free trail is expired so come here to revise the topics again. Please make upload more such useful videos on RUclips

This is perfect but what if I wanted the new sheet to be saved as values and not formulas

Thank you Alan for this great video. 👍 Appreciate you sharing ur knowledge with us

You are simply awsome. The way you explains everything is very structured with proper concepts. You are really a gem in this field

God bless You! Really Help me

Hi Alan , thank you for the tips i found your video very helpful, however as I'm completely new to the excel and everything i know is pretty much from videos like yours. My problem is as for most of the tasks i am using query formulas , but now i just stuck where i have a column which i put into the cell picture of barcodes . For example here is a simple formula which i am using : =QUERY('MASTER FILE'!A2:J,"SELECT A ,B,J,D WHERE D ="""&D3&""" ") . So where is the column 'J' there are many barcodes which i would like somehow to populate with the other columns . The formula is working but no matter where i choose to put J , simply it does not show anything on that specific column. Is there any chance to modify or actually how to populate certain columns depending on the drop down menu as it is in the formula WHERE D column = D3 . For example i got a recruiting big master file end collecting all data . My idea is all pictures personal document photos to put them into the cell for future audit if need. I just want simply to populate what i got as a picture in any column to come along with the others. Thank you so much

I kept getting #SPILL errors when adding the offset portion of the formula

hello is there away to sum live data coming in to one cell another word i want the sum of live data and only if the live data above 500 to give me the sum total of the above 500 live data coming in

You are amazing! Thank you!

Thank you. Very helpful!

I was looking shortcut without mouse

Very nice tutorial! Thank you very much - you helped a lot!

how to open a worksheet which is available in another location and find the string?

Thanks for the help man, have been clicking yes and typing code each time I open the file 🙂

Very helpful here in 2021!

Love this video and have subscribed to your skillshare page. Everything is working great! I am wondering how I can get the code to start over automatically on the next column. I have several columns and it would be great to have the code go one by one. Thanks in advance!

Thank you.

This is great Alan, is there away of saving the sheets to a new location all in one go?

Hi, in my computer the excel returns "Reference isn't valid" when I change the formula to the name I create

Can I get this workbook with codes I have same situation .... Please help

I'm wanting to add monthly computer generated reports to a living report (summary document) instead of making seperate monthly reports. So currently I'm processing monthly computer generated reports (which I can do using your method) but I'd want to also then take those monthly processed reports (datasets) and link them to the living summary report which is totals and a graphs that people in the business use... Could you do a video on that please?

Good

Thank you very helpful