comparing sheets

[mohan08]

Hi Team,

i have need to compare two sheet and identify the new item and deleted item using the below formula on column C on respective Sheets

Can you help me with the macro with the Formula and Copy the line Respective Sheets.

Sheet 1 - Rows with Value "New Item" to New item Sheet
Sheet 2 - Rows With Value "Deleted Item" to Deleted item sheet

 

[AlanSidman]

Join the two tables within Power Query/Get and Transform with a full outer Join. You can then see which are new in your second table and which are missing from the second table.

 

[anishms]

Hi Team,

i have need to compare two sheet and identify the new item and deleted item using the below formula on column C on respective Sheets

Can you help me with the macro with the Formula and Copy the line Respective Sheets.

Sheet 1 - Rows with Value "New Item" to New item Sheet
Sheet 2 - Rows With Value "Deleted Item" to Deleted item sheet

Check this

 

[Marc L]

Can you help me with the macro with the Formula and Copy the line Respective Sheets.

Hi, according to your attachment both columns C of Sheet1 & Sheet2 are useless with this VBA demonstration :​

Sub Demo1()
    For N% = 1 To 2
        With Sheets(3 - N).[A1].CurrentRegion
             S$ = .Range("B2:B" & .Rows.Count).Address(, , , True)
        End With
             Sheets(N + 2).UsedRange.Clear
        With Sheets(N)
            .[K2].Formula = "=ISNA(MATCH(B2," & S & ",0))"
            .[A1].CurrentRegion.AdvancedFilter 2, .[K1:K2], Sheets(N + 2).[A1]
            .[K2].Clear
        End With
    Next
End Sub

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

​