thank you so much! i've been trying to use do it for so long. and finally done it after watching ur video 2- 3 times! i just want to say thank you so much!
Hi Robert. Very impressive. is there any way I do the same using excel 2003?. I did not find the camera nor the name manager. So I could not do it. Thank you very much for your time.
great video...worked great! but what if I want to copy that to another sheet so I can select another image...same choices but I want to select turtle on one sheet and snake on another one...can it be done?
Sorry to post here. I like to know how can i sort the picture accordingly when i sort my data? My picture seems not to move with the data when i sort it. i went to the properties and set move but dont size with cell but still it cant be sorted. can you assist me?
Robert, sorry for 4 months' delay in replying... too many things keeping me busy.
Yes, you can show random pictures. You can use the function RANDBETWEEN to determine a row number within the limits you have. Instead of matching a name to a row number, simply pick the randomly generated row number and this will be it.
Hi Robert great tutorial is there any way I can use this method to have random images from sheet2 appear on sheet1 without again needing to use visual basics? Thanks.
@robertholland26 yes, you can. Since you're looking up a row number, you may simply use the random between function to set the possible range of random pictures to show.
You sir, are my hero!
ZesPak 4 weeks ago
Is the camera tool necessary?
superbeast326 3 months ago
Thanks a lot u've saved me alot of hassle. Keep up the good work
THEsolidnake16 4 months ago
thank you so much! i've been trying to use do it for so long. and finally done it after watching ur video 2- 3 times! i just want to say thank you so much!
janice524 9 months ago
Can i ask, when you open a new window, how do you get it so that it shows some perspective rather than a flat window?
Gweely1971 10 months ago
hi robert, how did u record the tutorial? seems very nice tho
skenfairux 11 months ago
Hi Robert. Very impressive. is there any way I do the same using excel 2003?. I did not find the camera nor the name manager. So I could not do it. Thank you very much for your time.
alternativeblue123 1 year ago
great video...worked great! but what if I want to copy that to another sheet so I can select another image...same choices but I want to select turtle on one sheet and snake on another one...can it be done?
thanks
Luc
luctherrien28 1 year ago
Sorry to post here. I like to know how can i sort the picture accordingly when i sort my data? My picture seems not to move with the data when i sort it. i went to the properties and set move but dont size with cell but still it cant be sorted. can you assist me?
kateku7 1 year ago
Thanks Robert, it is nice tutorial.
rmabhani 1 year ago
Thanks a lot for this video!! It really helped me a lot. The time you spent, was worth it.
julianjordanb 1 year ago
Robert, sorry for 4 months' delay in replying... too many things keeping me busy.
Yes, you can show random pictures. You can use the function RANDBETWEEN to determine a row number within the limits you have. Instead of matching a name to a row number, simply pick the randomly generated row number and this will be it.
cmart02 2 years ago
Hi Robert great tutorial is there any way I can use this method to have random images from sheet2 appear on sheet1 without again needing to use visual basics? Thanks.
robertholland26 2 years ago
@robertholland26 yes, you can. Since you're looking up a row number, you may simply use the random between function to set the possible range of random pictures to show.
cmart02 1 year ago
@robertholland26 hello robert i have on problem with what you are posting can u please reply.
hassobh 1 year ago