I’m trying to do a comparison between 2 sheets Before and After on column C,G,M.
If on a row, I have a combination of the 3 columns from sheet Before, not showing in the sheets After, it would transfer the 3 columns values into sheet: Recap in column A, B and C.
The thing to remember is that each combinations will not automatically be on the same row of the other sheet, so the macro needs to look at all combinations and see it it exist in the other sheets. If it doesn’t, then it transfer the 3 values in the sheet Recap.
How can I do that?
Thanks for your help