How to compare a row data from one worksheet to another worksheet
 

Hi All,

Is there any way I can compare a row data of one excel sheet to that from
another
excel sheet.

The sample data would be as follows:
Worksheet1 name : Element list old
Contains columns name and data as follows
Column name: Element Name, Type, Category, Valid
Data.............: ABC,L,Major,Yes

Worksheet2 name : Element list updated
Contains columns name and data as follows

Column name: Element Name, Type, Category, Valid
Data.............: ABC,M,Minor,No

If any row do not match, then I would like to display either the rows or
columns data from Worksheet2 in a new worksheet.

Any assistance will be much appreciated.

How to compare a row data from one worksheet to another worksheet
 

Excel 2007 PivotTable
Tables, Advanced Filter
No formulas needed.
http://www.mediafire.com/file/4mg0e2mnj0z/07_02_09.xlsx

How to compare a row data from one worksheet to another worksh
 

Hi Herbert,

Thank you very much for such a detail help.
I was able to open the file, thou it gave some warning message while
converting the file from newer version to my version that I am using.

Is it possible to save the file in Excel 2003, this will help in seeing the
full functionality.

Thanks once again for a generous help.
Regards
Bash

"Herbert Seidenberg" wrote:

Excel 2007 PivotTable
Tables, Advanced Filter
No formulas needed.
http://www.mediafire.com/file/4mg0e2mnj0z/07_02_09.xlsx

How to compare a row data from one worksheet to another worksh
 

For $91.99 you can buy Excel 2007,
which is less than three hours of conversion work.
Besides, nifty features like dynamic conditional formatting,
dynamic horizontal tables, structured references
and cool tables styles would be lost.

How to compare a row data from one worksheet to another worksh
 

Thanks Herbert for the suggestion.

However at the moment, the organization I am working for will take some time
to buy the excel 2007, as it has to be for the complete organization and
they will not entertain my single request.

I can see the point and benefit of the new version, but for now
unfortunately I am trying to sort this issue of comparing on my own.

I will highly appreciate if you could please save the same in excel 2003.

Thanks

"Herbert Seidenberg" wrote:

For $91.99 you can buy Excel 2007,
which is less than three hours of conversion work.
Besides, nifty features like dynamic conditional formatting,
dynamic horizontal tables, structured references
and cool tables styles would be lost.

How to compare a row data from one worksheet to another worksh
 

Excel 2007 PivotTable
Due to popular request...
Automated with macro.
http://www.mediafire.com/file/zzmnvtnznyt/07_03_09.xlsm