Highlighted unmatched data between two sheets and merge data in summary

Closed
leapout Posts 20 Registration date Monday March 1, 2021 Status Member Last seen April 26, 2022 - Updated on Jun 4, 2021 at 01:10 PM
leapout Posts 20 Registration date Monday March 1, 2021 Status Member Last seen April 26, 2022 - Aug 11, 2021 at 09:20 AM
Hello,
I have two sheets contain data from COL A: COL G if there are new data in sheet1 but are not existed in sheet2 then should highlight by red color in sheet1 and if there are new data in sheet2 but are not existed in sheet1 then should highlight by red color in sheet1 and merge all of data in a new sheet " summary" with the same borders and formatting as in two sheets and with considering if I change any data in two sheets then should update in sheet " summary" and change the highlighted in two sheets
note: my data are about 2000 rows
sheet1


sheet2


summary




System Configuration: Windows / Chrome 90.0.4430.212

1 response

leapout Posts 20 Registration date Monday March 1, 2021 Status Member Last seen April 26, 2022 1
Aug 11, 2021 at 09:20 AM
any help or not clear this subject?
0