• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

comparing sheets

mohan08

Member
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
 

Attachments

  • Chandoo_Help.xlsx
    10.5 KB · Views: 6
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.
 
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
 

Attachments

  • Chandoo_Help.xlsm
    23.8 KB · Views: 6
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 :​
Code:
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 !​
 
Back
Top