Compare and find similar values present in column entire A

Hello Everyone

In the SummaryResult Excel, (Attached) . It is having 2 sheets. MissingData and NewlyaddedData.

if 1st Sheet or/And 2nd Sheet, A3 having value aaa and A6 also having aaa (like the same values present in A Column only) then Entire ROW from those sheets will be written separately to new *AAA* Sheet in the Same SummaryResult.xlsx

if 1st Sheet or/And 2nd Sheet, A4 having value bbb and A5 also bbb (the same values present in A Column only)then entire ROW from those sheets will be written separately to new *BBB* sheet in the Same SummaryResult.xlsx

I have attached upated Required SummaryResult.xlxs

Please have a look for ref. Sheet AAA and BBB

Thank you

[Santosh Biradar]

@Image Analyst

Please have a look. You are time and responce will be very appriciable.