I have two SQL queries pasted in a worksheet and i want to compare these 2
SQLS and highlight the difference with a color.

can u anyone suggest a solution cause im badly stuck and not able to progress?
--
thanx..
Bhavtosh

Take a look at

http://cpearson.com/excel/duplicat.htm

In article ,
"Bhavtosh" wrote:

I have two SQL queries pasted in a worksheet and i want to compare these 2
SQLS and highlight the difference with a color.

can u anyone suggest a solution cause im badly stuck and not able to progress?

Excel wasn't really intended as a tool to generate differences between 2 text
files. There are programs available that will do that, however. MS's WINDIFF,
which, AIR, comes with some versions of Office, comes to mind.

On Mon, 21 Feb 2005 01:43:03 -0800, "Bhavtosh"
wrote:

I have two SQL queries pasted in a worksheet and i want to compare these 2
SQLS and highlight the difference with a color.

can u anyone suggest a solution cause im badly stuck and not able to
progress?

thanx for prompt reply. actualy i wanted to do this in a macro so that my
addin can have this feature... any help on this wud of help.

thanx
bahvtosh

"Myrna Larson" wrote:

Excel wasn't really intended as a tool to generate differences between 2 text
files. There are programs available that will do that, however. MS's WINDIFF,
which, AIR, comes with some versions of Office, comes to mind.

On Mon, 21 Feb 2005 01:43:03 -0800, "Bhavtosh"
wrote:

I have two SQL queries pasted in a worksheet and i want to compare these 2
SQLS and highlight the difference with a color.

can u anyone suggest a solution cause im badly stuck and not able to
progress?

This is NOT a trivial task -- whether to ignore changes in whitespace or not;
whether to ignore case, etc; identifying whether a group of "different" lines
represent lines that have been inserted, or lines that have been deleted, or
lines that have been moved, etc.


On Mon, 21 Feb 2005 20:37:03 -0800, "Bhavtosh"
wrote:

thanx for prompt reply. actualy i wanted to do this in a macro so that my
addin can have this feature... any help on this wud of help.

thanx
bahvtosh

"Myrna Larson" wrote:

Excel wasn't really intended as a tool to generate differences between 2
text
files. There are programs available that will do that, however. MS's
WINDIFF,
which, AIR, comes with some versions of Office, comes to mind.

On Mon, 21 Feb 2005 01:43:03 -0800, "Bhavtosh"
wrote:

I have two SQL queries pasted in a worksheet and i want to compare these 2
SQLS and highlight the difference with a color.

can u anyone suggest a solution cause im badly stuck and not able to
progress?