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