Need comparison of two excel files macro

Hi Any body help me to write a code for comparing two excel files and get result next sheet or new anything will be ok.

Please guide me what is best possible way to get result

Note :
One is Old revision another latest revision please compare with older version and give me what is new in latest revision

Nick's picture

depends on the files.. we

depends on the files..

we have this that might be of use:
http://excelexperts.com/VBA-Tips-Compare-2-Data-Sets