Comparison

[WebStone]

Hello all...I would like to ask if anybody has a macro that can compare between 2 different excel files and output it with the same equal date.

Like for an example, my boss want's me to compare his sale record last week with my own record and if that so we have the same record in that specific date. I know a little bit hard but that's it.

Thanks everybody.

[Bob Phillips]

The problem is that there are so many things to compare, values, formulae, colours, conditonal formatting, data validation, and so on. Thus, if you have complex comparison, it might be simpler to buy a comparison product, such as http://www.exceldiff.com/.

If it is just two simple spreadsheets that you wish to compare the values, show us the two sheets, tell us how you identify differences (from a business perspective) and how you want to see the differences reported, and we can knock up some quick code to get you started.