Compare data in two worksheets

B

Barry

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
 

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

Compare & highlight changes between two worksheets? 2
Compare worksheets in two workbooks 1
COMPARING TWO COLUMNS OF INFORMATION, ACROSS TWO WORKSHEETS 2
compare data in 2 worksheets 1
Compare data (2 columns) from 2 worksheets within a workbook 2
comparing two worksheets 1
Comparing 2 worksheets in Excel 2007 1
view 2 different worksheets within the Wrkbk 7

Top