Macro for worksheet by row

[Wondering25]

Hi
I created a worksheet with a dropdown for each row of the budget worksheet. The dropdown allows the user to determine if they want to use the recommended monthly budget allocation methodology or manually enter the data by month. Since the worksheet requires you to make this determination for each row, I would like to define a macro that will know to zero out the cells in row 2 columns J thru V when "Manually" is selected from the drop-down list. When the user moves to Row 3 and selects "manual", i would like the macro to know to zero out all cells in Row 3 columns J thru V to allow the user to enter in their allocation by month and remove all predefined allocations. Is there a way this can be done? I want to make a master worksheet and replicate it for each department that will need to be budgeted.

 

[rollis13]

This macro, to be pasted in the sheet's vbe module, will clear your cells when "Manually" is chosen. I'm supposing that your dropdown is in column A. See if you can adapt it to your project.

Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Cells.CountLarge > 1 And Intersect(Target, Range("A:A")) Is Nothing Then Exit Sub '<- change range as needed
    If Target.Value = "Manually" Then             '<- match text and case with Validation Dropdown
        Application.EnableEvents = False          'avoids event redundant triggering
        Range(Cells(Target.Row, "J"), Cells(Target.Row, "V")).ClearContents
        Application.EnableEvents = True
    End If
End Sub