working with 2 different worksheets, how can I verify the data
 

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

working with 2 different worksheets, how can I verify the data
 

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

working with 2 different worksheets, how can I verify the data
 

Jim,

What i want to do is I have a worksheet with several hundred lines of
vehicle details i.e. Serial No, Registration No, Date In Service etc.
on a monthly basis Head office send me a similar worksheet that I have to
confirm the details for billing purposes.

the detail on the worksheets can vary as vehicles are transfered into and
out of my control during the month and I need to do a verification as to
where the vehicles are and what dates they are either transfered in or out.

What I wanted to do was to see if there was some calculation I could use to
check each line on my worksheet against the worksheet from head office. its
not that there are only a few transferes but there could be hundreds

thanking you in anticipation

Regards

Bernie

"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