Rock my World

[rascl5]

Need to know how to use a 'date field', specifically in a chosen column, (lets say column C) that will transfer an entire row of information to another tab - next in line.
Example 03/19/09 to the 'tab/worksheet' labeled 03?
Is this possible?

 

[rascl5]

Try

Private Sub Worksheet_Change(ByVal Target As Range)
Dim LR As Long
If Target.Column = 6 Then
    Application.EnableEvents = False
    With Sheets(Format(Month(Target.Value), "00"))
        LR = .Range("A" & Rows.Count).End(xlUp).Row
        Range("A" & Target.Row & ":R" & Target.Row).Copy Destination:=.Range("A" & LR + 1)
    End With
    Target.EntireRow.Delete
    Application.EnableEvents = True
End If
End Sub

Sorry - not a thing. Is there anything else I may not be providing that would help explain the situation at hand?

 

[VoG]

1. Make sure that macros are enabled: Tools > Macro > Security.

2. Make sure that events are enabled: In the code window press CTRL + G to open the Immediate Window, type in

Application.EnableEvents = True

and press Enter.

 

[rascl5]

1. Make sure that macros are enabled: Tools > Macro > Security.

2. Make sure that events are enabled: In the code window press CTRL + G to open the Immediate Window, type in

Application.EnableEvents = True

and press Enter.

No Luck - must be something on my end -thank you.