up vote 1 down vote favorite
share [g+] share [fb]

Possible Duplicate:
Compare between Excel worksheets

The title actually explains it all.

I would like to be able to compare two Excel Sheets in one Excel document.

Comparing two different files can be accomplished by going to the "View Tab" and clicking Arrange All / Split.

But how can I compare two excel sheets in the same document?

Help is very appreciated!

Thanks SuperUsers ;p

link|improve this question
50% accept rate
Some of the options in this answer might work for you: superuser.com/questions/18626/… – arathorn Aug 25 '09 at 14:19
feedback

closed as exact duplicate by random♦, Diago Jan 15 '10 at 6:48

This question covers exactly the same ground as earlier questions on this topic; its answers may be merged with another identical question. See the FAQ for guidance on how to improve it.

4 Answers

up vote 1 down vote

I'm not sure if that is possible but as a quick and dirty fix you could do a right click copy sheet to a new excel file and do the comparison against that.

link|improve this answer
But then it's a source of mistakes with the copy/edition/copy back : easy to lose cells in the process. – Gnoupi Aug 25 '09 at 13:42
I think this is a good scheme if you cannot compare two sheets within a XLS. The entire sheet will get copied out to another XLS -- this is not a cut-and-paste operation and I doubt if you will loose any cells. – nik Aug 26 '09 at 1:48
If you wanted to be sure you were working on the right version you could move the sheet instead then move it back when you're done with your comparison. – Col Aug 26 '09 at 7:33
feedback
up vote 1 down vote

You can open the same workbook twice, the second time as Read-Only. Then you can compare them side-by-side on the screen, just like two different workbooks.

This way, you will never lose data due to copy-and-paste errors, or forgetting to put any changes back in the proper workbook.

link|improve this answer
feedback
up vote 0 down vote

I'm not sure what sort of comparison you are after, but I have used the macro from here to compare two worksheets before. It shows the differences in a new sheet. Might be what your after.

link|improve this answer
I actually want to compare two sheets side by side and look at differences.. – Shaharyar Aug 25 '09 at 12:52
feedback
up vote 0 down vote

I find Cols answer quite suitable for the purpose.
If you need to script for checking differences automatically
you can use the methods described in this question.

link|improve this answer
feedback

Not the answer you're looking for? Browse other questions tagged or ask your own question.