DaveF,

I have no code, yet, for this question. I am not sure how to start? And,
the code to format the text files has many, many pages. I am comparing 75
different reports.

I am sure you do not want to see all of this?

phmckeever

"Dave F" wrote:

What's the code you have for your macro so far?

"phmckeever" wrote:

Two Oracle databases are being run parallel. The data in these databases
need to be verified as being the same.

sqlplus code has been developed to generates a text file of differences
between the data in the databases.

I am using an excel macro to format the data produced by the sqlplus code.
The rows that are selected have identical numbers in the first column of the
report. The last piece that I am trying to accomplish is as follows:

1. Find the two duplicate numbers in the first column of the report,
2. Select the two duplicate number rows,
3. Find the cells in the rows that are different, and , finally,
4. Highlight the different cell values.

Can up help me?

phmckeever