Diary for 18-01-2010
18th Useful Excel Worksheet Comparison
One of our current projects involves comparing multiple datasets from a csv database extract to show which records have been removed or updated. To do this there is an original worksheet that gives the default baseline data on a given date. Then a second worksheet is copied into this file for comparison. This happens on a weekly reporting cycle. I hunted for a method to find any original records that had been deleted in the weekly report. I found a great little tutorial that did the trick...read the rest of the story
Alacrify Ltd. 01300 320076. jon@alacrify.co.uk
