Auto select multiple drop down menu base on the info I entered on a specific column

you could show the macro

I clicked on upload, the macro file didn't show up. Then I used basic upload, I found the file but when I tried to upload it. It said invalid file.

It's .xltm format...

Thanks,

Try copying and pasting the macro only.

Sorry, tried that. Actually the macro only putting the category ID to the 4th column when a drop down menu selected and that's it. So hope it is clear enough to understand my question. Thank you for your suggestion

By the way, does anyone have idea how to solve my issues? Appreciate

Here is the Macro, thanks

Private Sub Worksheet_Change(ByVal Target As Range)
Dim rngDV As Range
Dim oldVal As String
Dim newVal As String
Dim lUsed As Long

If Target.count > 1 Then GoTo exitHandler

On Error Resume Next
Set rngDV = Cells.SpecialCells(xlCellTypeAllValidation)
On Error GoTo exitHandler

If rngDV Is Nothing Then GoTo exitHandler

If Intersect(Target, rngDV) Is Nothing Then
'do nothing
Else
Application.EnableEvents = False
newVal = Target.Value
Application.Undo
'oldVal = Target.Value
Target.Value = newVal
'If Target.Column = 3 Then
Cells(Target.row, 4).Value = opRange(Target.Value, Target.row, 4)
End If
exitHandler:
Application.EnableEvents = True
End Sub

At most, the macro only fills the cell in column D for the target.row, so what else do you need to fill? The rest are controls that mostly point to the exit door

Yes, the Macro above only fill the cell in column D. What I really need is:

We enter our product title in Column E, then both Category ID (Column D)and attributes (Column FGHI) should be automatically selected based on the information we entered on the column E. By the way, those attributes are drop down menu, not sure if it matters.

Thanks RCM