View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
duketter duketter is offline
external usenet poster
 
Posts: 63
Default compare all data in one worksheet to another

Excel 2007 - I would like to compare all the data in one worksheet
(50+columns and 800 rows) to another worksheet and identify any differences.
The worksheets are set up the exact same way regarding column names, number
of columns, etc.

I know there is at least one difference in one of the cells in this entire
worksheet but there may be more. How can I do this?