ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel Macro (https://www.excelbanter.com/excel-programming/370793-excel-macro.html)

phmckeever

Excel Macro
 
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 you help me?

phmckeever




All times are GMT +1. The time now is 01:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com