Add a third sheet and look for the differences something like this...

In Cell A1 of the added sheet

=if(Sheet1!A1<Sheet2!A1, "Difference", "")

Copy this formula (or something similar) to cover all of the cells in the
two sheets you want to compare and all of the differences should show up...
--
HTH...

Jim Thomlinson


"data verification" wrote:

I have more or less the same data in 2 different worksheets I need to verify
the data is there a way of doing this rather than having to go through each
entry