hi... I read a good thread here on how to add a picture to a comment.... this works just the way i want it to if i want to cut a cell with a picture in it and paste it to another cells and have the picture appear..... my problem is...
I am making a list of pictures on sheet two using the comment feature on sheet 2 in row B.... row A with be a number ie 1,2,3,4,5, to go with each picture... I want to set up sheet 1 so that if i select the #1,2,3,4,5, from a drop down in a1 then the picture (cell) next to that number on sheet two will copy paste to sheet 1 b1... any ideas?
I am making a list of pictures on sheet two using the comment feature on sheet 2 in row B.... row A with be a number ie 1,2,3,4,5, to go with each picture... I want to set up sheet 1 so that if i select the #1,2,3,4,5, from a drop down in a1 then the picture (cell) next to that number on sheet two will copy paste to sheet 1 b1... any ideas?
