I don't know what to call it. That's why I cant Google it : )

[HeRoseInThree]

First Name

Last name

Suffix

Complete name

Last, First

Phone

DOB

Hire

Term

SSN

Tenure

Phone

SSN

Age

john

doe

jr

John Doe Jr

Doe, John

8158675309​

5/21/73​

11/28/2017​

123-45-6789

2 years, 11 months, 5 days

(815) 867 - 5309

6789

47

If I enter a date in the term column (j2) is there a way to grab the info in row 2 and put it into another sheet named Terms?

 

[Logit]

Option Explicit

Private Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo errhandler
    
    If Intersect(Target, Range("J:J")) Is Nothing Then Exit Sub
    Application.EnableEvents = False
    
    Target.EntireRow.Copy Sheets("Sheet2").Cells(Rows.Count, "A").End(xlUp).Offset(1, 0)
    
    Application.EnableEvents = True
    
errhandler:
    Application.EnableEvents = True
    
End Sub

 

[HeRoseInThree]

Option Explicit

Private Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo errhandler
   
    If Intersect(Target, Range("J:J")) Is Nothing Then Exit Sub
    Application.EnableEvents = False
   
    Target.EntireRow.Copy Sheets("Sheet2").Cells(Rows.Count, "A").End(xlUp).Offset(1, 0)
   
    Application.EnableEvents = True
   
errhandler:
    Application.EnableEvents = True
   
End Sub

Thank you SO much!!!

 

[Logit]

You are welcome.