I am using Excel 2000 on Windows XP. I am self employed as a contractor and I receive a statement from the company I am contracted to for the work I have performed. In the statement I receive, I want to be able to use my generated Excel spreadsheet to compare with their statement. I inspect properties twice per month. I receive, on average, approximately one new property per day (avg. 30 per month). These properties are then added to my inventory. At the same time I have properties that sell on about the same average. My total inventory ranges up to about 200, give or take. At then end of each month I receive a statement indicating the properties I have inspected for that month. Each property is assigned a case number which remains with that property until sold, i.e. XXX-XXXXXX, (in this 9 digit format). What I would like to do is be able to compare their list, which can be put into an Excel spreadsheet, with my list using the case number as the comparison factor. If I have inspected the property twice during the month then that case number will be listed twice on their statement as well as my generated Excel spreadsheet. If it is inspected once then it is only listed once in both their statement and my list as well. I am wanting to know if there is a way to automatically have Excel make the comparison for me so that I don't have to manually verify or compare each one individually. And if it can be done, can it tell me which one or ones (by case number), do not agree, in red or some other color? I hope I have made this clear enough. If not I'll be glad to provide more information.
Bob Lankford
Bob Lankford