Excel 2000 Compare Worksheet

J

jeff

Hi,

On July 6, Dave Peterson wrote this:

jeff
------------------------------------------------
It depends.

Myrna Larson and and Bill Manville wrote an addin that
compares two worksheets
on a cell-by-cell basis.

A1 is compared with A1. B99 to B99. If one of the users
inserted (or deleted)
rows (or columns), then this cell-by-cell comparison
breaks down.

Here's a link to the program (kept at Chip Pearson's
site):
http://www.cpearson.com/excel/whatsnew.htm
look for compare.xla

But if one of your consultants inserted a new row 1 (or
deleted column A), then
you'd find a bunch of changes right away.
 

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

Top