Formula or VBA

[bcs0262cop]

I have two worksheets in a workbook. In worksheet #1 I have a dropdown in cell C26, which contains 7 names. I would like a formula or VBA that when any name, selected from the dropdown, is selected the data in cell A26 is copied to the worksheet #2 in cell #D5. I have tried several formulas, they will work if only one criteria is entered from the dropdown. I am having issues

 

[bcs0262cop]

Define:
I have a dropdown in cell C26, which contains 7 names.

What is a Dropdown?
Do you mean a Data Validation list?

Yes a data validation list

 

[My Aswer Is This]

What was wrong with code in post #9

 

[My Aswer Is This]

Try this:

This is a sheet change again script.
You must right click on the sheet tab and post in this code
When you make a change to Range("C26") the script will run.

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$C$26" Then
Sheet2.Range("D5").Value = Target.Value
End If
End Sub