98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Comparing spreadsheets
Comparing spreadsheets
Resolved · Low Priority · Version 2003
Amanda has attended:
Excel Intermediate course
Excel Advanced course
Comparing spreadsheets
How to identify discrepencies between two different spreadsheets
RE: comparing spreadsheets
Hello Amanda
Thank you for your question and welcome to the forum.
There is a feature called Compare and Merge in Excel, which you can use to compare one spreadsheet against another. In order for this to work though, you need to make the workbook shared first (Tools - Share Workbook, then tick the Allow changes by more than one user box).
The Compare and Merge feature is designed to be used so that if you have multiple copies of the same workbook, you can compare one workbook against another and then decide how you want to merge data from one workbook into another.
I hope this helps.
Amanda
Fri 12 Dec 2008: Automatically marked as resolved.
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Creating charts in Excel 2010Here's how to present your data in a chart format: |