>Hi Naomi.
>
>I would load both spreadsheets into temporary sql tables and take the difference from there. It'll be easier and quicker..
This is what I ended up doing. I thought there is a simpler way to do this through Excel directly instead of loading 2 huge files, but I got the same advice from somebody else, so I decided to load them into my local (I'm going to truncate these two tables now).
If it's not broken, fix it until it is.
My Blog