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

 

[mumps]

they will work if only one criteria is entered from the dropdown

What do you mean by this. Please use a few examples to describe what you are trying to do.

 

[bcs0262cop]

What do you mean by this. Please use a few examples to describe what you are trying

 

[mumps]

???????

 

[bcs0262cop]

The dropdown contains names, i.e. John, Jim Charles, Mike, Sarah, Trace, Victor. If the name Charles, Mike, Sarah, or Trace is selected I want the value in cell A34 to be copied and pasted into Cell D24 in the second sheet. I can writ a formula that will copy if I just use one name, but not sure how to write it if any one of those names are selected

 

[mumps]

What formula are you currently using?

 

[bcs0262cop]

What formula are you currently using?

=FILTER('2024_07_15'!A34,'2024_07_15'!C34="Charles") If I add more names I get an error "too many arguments

 

[Joe4]

Take a look here: How To Use Excel FILTER Function With Multiple Criteria

 

[mumps]

Copy and paste this macro into the worksheet code module. Do the following: right click the tab name for the sheet containing the drop down in C26 and click 'View Code'. Paste the macro into the empty code window that opens up. Change the destination sheet name (in red) to suit your needs. Close the code window to return to your sheet. Make a selection in the drop down.

Private Sub Worksheet_Change(ByVal Target As Range)
    If Intersect(Target, Range("C26")) Is Nothing Then Exit Sub
    Select Case Target.Value
        Case "Charles", "Mike", "Sarah", "Trace"
            Sheets("Sheet2").Range("D24") = Range("A34")
    End Select
End Sub

 

[My Aswer Is This]

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

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