Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Macros
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Macros
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Macros
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How to remove excel macros still there after normal delete? | Excel Discussion (Misc queries) | |||
I deleted all macros in Excel but still get dialog box | Excel Discussion (Misc queries) | |||
Are macros created in Excel 2003 compatible with Excel 5.0/95? | Excel Discussion (Misc queries) | |||
How do I update Excel 2000 macros to work in Excel 2002? | Excel Discussion (Misc queries) |