QC of Excel Worksheets

[fieldy]

Hi,

I am new to this posting so apologize up front for any wrong doing

I would like to find out if there is any way of comparing 2 worksheets, so that you can QC that one has the same data fields etc as another after a merge/copy & paste?

I tried using an MD5 checksum program, but this would not validate all of the data, and after checking through the worksheets, showed differences?

Is there anything that can accomodate this in Excel or even another third party tool?

Thanks in advance for your help,

Fieldy

 

[agihcam]

Hi -
Welcome to the board.

Download Colo's HTML Maker utility for displaying your Excel Worksheet on the board.

this can be found at the bottom of the page.

 

[fieldy]

Hi agihcam,

Many thanks for replying. I cannot display the worksheet as it has someone else's data in it so is there anything you would recommend for me to be able to do a comparison of the 2 worksheets?

Thanks again,

Paul