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

B

bash

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.
 
B

bash

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
 
H

Herbert Seidenberg

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.
 
B

bash

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
How To Lookup a full row if it contain a text in a spec coloumn from diffrent sheet? 1
How do I use the text content of a cell as a worksheet reference? 9
Returning a Value from Another Worksheet 2
Merging from an Excel file with graphics 1
Construct table from selected rows 4
Sort a coloum on one worksheet according to another coloumn on ano 0
matching & combining data from seperate worksheets 2

Top