ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I compare two Excel worksheets for cell differences? (https://www.excelbanter.com/excel-discussion-misc-queries/16682-how-do-i-compare-two-excel-worksheets-cell-differences.html)

jjrhiv

How do I compare two Excel worksheets for cell differences?
 
This is a physical inventory process. An employee, using a barcode reader,
will populate the cells of one column in a worksheet with asset IDs that are
located at a facility. Once done, the employee must compare the cell values
of the worksheet that he or she has populated to the cell values of the
inventory roster. The desired outcome is to produce a plus/delta report based
on the comparison of the two worksheets.
Thanks!

savage_planet

How do I compare two Excel worksheets for cell differences?
 

You can find software that finds the differences between Excel workbooks
at

http://www.florencesoft.com

It highlights cell differences and produces a cell-by-cell difference
report in a new Excel workbook.

It is free to use for the first 30 days. It has quite a lot of useful
options such as the ability to hide matching rows, making the
differences stand out.


--
savage_planet


All times are GMT +1. The time now is 04:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com