I have a master sheet and Sub sheets with names. I am using a dropdown for the Dr selection. And want the cells in that row to copy to the Dr name sheet but still have the master list also.
So I was reading another page here and found this code and it works but only for 1 row. Even I click on another rows drop down it still inserts the first row.
I need to be able to do this for each row and it copy the cells to the correct sheet.
Here is the original code I have been trying to make work.
So I was reading another page here and found this code and it works but only for 1 row. Even I click on another rows drop down it still inserts the first row.
I need to be able to do this for each row and it copy the cells to the correct sheet.
Here is the original code I have been trying to make work.
VBA Code:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.CountLarge > 1 Then Exit Sub
If Intersect(Target, Range("E2")) Is Nothing Then Exit Sub
Range("B2:I2").Copy Sheets(Target.Value).Cells(Sheets(Target.Value).Rows.Count, "A").End(xlUp).Offset(1)
End Sub