byronmunya
08-31-2010, 07:53 AM
Is it possible to compare two worksheets, basically the same excel file, lets say i take a snapshot of the file at the beginning of the month in sheet1 then at the end of month i take a second snapshot of the same file in sheet2 and then compare the two to see what has changed and return the result in sheet3 e.g which file was deleted, added and modified