Hi Experts

I am a long time browser but very new poster.

I am trying to add functionality to an excel workbook which shows a picture of a users signature.

So I have a drop down list with the various users who are inputting the data for the particular flight (its a flight planning tool, irrelevant to the problem) using data validation.

What I am trying to achieve is to show the image of their signatures (which I have scanned in to the excel document on another worksheet called "Raw Data") when they select their names from the drop down list.

So if i could create a macro code that goes something like:

Sub Insert_Sig()
If Range("L3").Value = "SMITH" Then
Raw Data.Shapes("SMITH").Copy
PLAN.Range("P3").Paste
End If

End Sub
SO basically I I want to write code that shows if cell L3 (the drop down menu) shows the name SMITH in there, then copy the picture (that I named SMITH) from the Raw Data worksheet to the same location as cell P3 in the PLAN worksheet.

I can change this to a CASE or write multiple IF statements but I am failing to get the basics up and running so I can tweak and improve the code.

(My Next problem will be how to make the previous signature disappear when a new name is selected from the drop down list.)

Thank you so much for any help you could provide.

Cheers