Re: find anywhere in A and B anything from C
the fixroutine uses row 2 for temporary storing of data. I took row 2 because in my sample of the file this row is not used for anything else. Of course any other location may be used. Just let me know where you can leave room for it. In my sample row 4 is used for headers.
Once I know where to go for temporary storing i will adjust the macro to also not tamper with the formatting of rows 5 onward.