D
Dedrie
We run a report from our system every day that shows all employees and a
bunch of demographic data on the employe. The number of rows varies based on
the number of employees in the database.
Is there a way to compare Monday's file to Tuesday's file in excel and get a
list of just the rows that changed from the prior day's file?
We have used a suggestion from (Martin W)
"Say you have two sheets in one file Sheet1 and Sheet2.
Then place this formula in A1 of Sheet3 and drag across
and then down as far as needed.
=IF(Sheet1!A1=Sheet2!A1,"",1)"
And that works really well (thanks Martin!) except we cannot control the
output of the file. So if an employee is newly hired, they don't
automatically go to the end of the report, they may show up in the middle of
the report, thus making all the rows after them appear as "1"s.
I'm know in MS Word you can compare two documents and see where they differ,
but haven't found similar functionality in Excel.
Does anyone have a macro or add-in that they could recommend. Several are
posted in other questions of this nature, but I have yet to find one on a
site that is still active.
Thanks in advance!!
bunch of demographic data on the employe. The number of rows varies based on
the number of employees in the database.
Is there a way to compare Monday's file to Tuesday's file in excel and get a
list of just the rows that changed from the prior day's file?
We have used a suggestion from (Martin W)
"Say you have two sheets in one file Sheet1 and Sheet2.
Then place this formula in A1 of Sheet3 and drag across
and then down as far as needed.
=IF(Sheet1!A1=Sheet2!A1,"",1)"
And that works really well (thanks Martin!) except we cannot control the
output of the file. So if an employee is newly hired, they don't
automatically go to the end of the report, they may show up in the middle of
the report, thus making all the rows after them appear as "1"s.
I'm know in MS Word you can compare two documents and see where they differ,
but haven't found similar functionality in Excel.
Does anyone have a macro or add-in that they could recommend. Several are
posted in other questions of this nature, but I have yet to find one on a
site that is still active.
Thanks in advance!!