Paul our new Excel guru has shown me a nifty little trick that im sure you’ll find interesting.
I was discussing how each month Open Site Explorer outputted new data and it was hard to integrate this into an existing (previous months) worksheet without potentially overwriting the work already done.
He rolled his eyes and said “easy… give me a minute” and then dropped this on me:
What it does is compare the (old) data in a tab called Sheet1 with the new data in Sheet2 using the first column (URL) as the measurement. Then all entries that are new will be labelled NA and can be integrated into the (old) work sheet.
Awesome stuff. Thanks Paul