I have searched thru several posts on this subject.
But I can't make it work for me. I amnot big on VBA coding, so I need help.
My problem is relatively simple.
I have a spreadsheet with annual project financials.
I would like to look at the year to date profit number and when it reaches a certain goal [% or $$], I would llike to display a picture [.jpg file] on the worksheet.
On another sheet I have booking numbers by salesperson.
Again, whichever salesperson reached his/her quota, I would like to display the respective picture.
The pictures can be inserted to the worksheet [no more than 10 pictures] or they can be retrived from the network.
Thanks for any help I can get.
Alan