excel training class - Compare and merge Excel documents

The UK's most regular instructor-led training courses.
Training information: excel training class · Microsoft excel training · Microsoft Excel Training London
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Compare and merge Excel documents

Melissa has attended:
Excel Introduction course

by - delegate Melissa [1 post] (2006 Dec 1 Fri, 16:40) Reply

Is there any way to compare two saved Excel spreadsheets, showing the changes as mark-ups?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003/XP	2008 Aug 21 Thu	Bloomsbury	0	FULL
2003/XP	2008 Aug 21 Thu	Bayswater	2	book now	£195	£205
2003/XP	2008 Aug 28 Thu	Southwark	0	FULL
2003/XP	2008 Aug 29 Fri	Tooting	0	FULL
2003/XP	2008 Sep 2 Tue	Bloomsbury	4	book now	£207	£215
2003/XP	2008 Sep 4 Thu	Bayswater	5	book now	£195	£205
Full Schedule: See all 141 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: Compare and merge Excel documents

by - trainer Richard platinum contributer [779 posts] (2006 Dec 4 Mon, 09:59) Reply

If you are referring to Word style markups, probably not.
You could use comments, which would involve manually inserting them as you go.

alternatively if it is numerical data you are comparing, you could make a thrid sheet that tracks the difference between the two sheets, and provides you with a result. You would need to know about formulas across multiple sheets.

Hope that helps.

Richard

· Advanced Excel Training - takes you to the next level
· Identifying Suitable Candidates For VBA For Excel Training
· Take the Anxiety out of Domestic Finances with Microsoft Excel
· Microsoft Excel Courses Teach Advanced Macro Techniques
· An Introduction to Microsoft Excel: Top Features for the Excel Novice

Excel tip:

Changing Excel file and worksheet defaults

The appearance of any new Excel files or any new worksheets that are inserted into a file are controlled by two template files, Book.xlt and Sheet.xlt.

By opening, modifying and saving these templates you can change the default settings for all new files and/or all newly inserted sheets.

Use Book.xlt to make change to defaults for new workbooks; and Sheet.xlt to change defaults for sheets.

If you can't find either of these files on your computer, you can create and save them yourself.

You can do this simply by creating a new workbook with the setting you want to use as your defaults; then saving them with the appropriate name in the XLStart folder. If you are using Office 2003, this is usually found in C:\Program Files\Microsoft Office\Office11\XLStart.

View all Excel hints and tips