title: VBA Macro to compare all cells of two Excel files
body: <p>I'm trying to compare two Excel files and store what's only there in the new file in one sheet and store what is only there in the old one in another sheet. (Basically <code>new - old = sheet1</code> and <code>old - new = sheet2</code>.) One <a href="https://stackoverflow.com/q/2871932/399268">SO answers</a> suggest to loop through all cells and do a simple comparison. I'm (very) new to VBA and Macros so I don't know how to do this. How is it done (or where can I learn this)?</p>