Update New Value Automatically

[Anand307]

Hi Team,

there are 3 tabs, Latest, Previous and Admin Tab

in latest tab, in cell A7 there is a new ID which is not found on Previous tab. (New value can appear in any cell, but only in column A of Latest tab))

Is there a way for this new ID's to automatically add in Admin tab, below the existing data

 

[Marc L]

Hi !​

• Save your workbook as binary format .xlsb …
  
  
• Paste this VBA event procedure to the Latest worksheet module :

Private Sub Worksheet_Change(ByVal Target As Range)
    With Target
        If .Column = 1 And .Row > 1 And .CountLarge = 1 Then _
            If IsError(Application.Match(.Value2, Sheets("Previous").UsedRange.Columns(1), 0)) Then _
                Sheets("Admin").Cells(Rows.Count, 1).End(xlUp)(2).Value2 = .Value2
    End With
End Sub

Do you like it ? So thanks to click on bottom right Like !​

​