I'm trying to figure out how to write this code. But the issue I have is, I consolidate all the files into one worksheet. Then I need to two different cells and compare them to see if they are equal or if they are not. If they are not I want it to count the cell and add it to a total in the summary.
Ex. Cell A: DN_111 compaired to Cell G: DN_112, DN_113, DN_114 but before it counts checks Cell H: DN_111. But after it counts I also want to be able to take every single one that is counted and display Cell C which will have various numbers & text. I know this should be a if then statement but I need help with writing this code. If anyone can please help, thanks in advance.