Drop down box selection to populate cell

[ipbr21054]

Afternoon.

I have a worksheet called INV
This is an invoice sheet so drop down box will be in column H from rows 27 - 36 inclusive.
Once a selection is made the selected value should be entered in the same row as its drop down box in column J

Thanks very much

 

[mumps]

Place the macro in the invoice sheet code module. Make a selection in the drop down list and press the ENTER key.

Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.CountLarge > 1 Then Exit Sub
    If Intersect(Target, Range("H27:H36")) Is Nothing Then Exit Sub
    Target.Offset(, 2) = Target
End Sub

 

[ipbr21054]

Thanks for the info

 

[mumps]

My pleasure.