ExcelBanter - Compare data in two worksheets

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Compare data in two worksheets (https://www.excelbanter.com/excel-worksheet-functions/224906-compare-data-two-worksheets.html)

barry

Compare data in two worksheets

Hello,
I need to compare data in two worksheets and produce a a new worksheet
with only the cells were the values differ, or highlight the cells that are
different, can this be done without having to use VB.

Barry

Ashish Mathur[_2_]

Compare data in two worksheets

Hi,

How is data presented on the two sheets. Please give an example.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Barry" wrote in message
...
Hello,
I need to compare data in two worksheets and produce a a new worksheet
with only the cells were the values differ, or highlight the cells that
are
different, can this be done without having to use VB.

Barry

All times are GMT +1. The time now is 11:57 PM.