Merge documents

The UK's most regular instructor-led training courses.
Training information: excel 2003 visual basic intermediate course · Excel courses · Microsoft Excel Training
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version 2007

Merge documents

Simon has attended:
Excel Intermediate course

by - delegate Simon [1 post] (2008 May 13 Tue, 11:13) Reply

How does one merge documents with slightly different fields?

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003/XP	2008 Aug 22 Fri	Bloomsbury	1	book now	£235	£240
2003/XP	2008 Aug 22 Fri	Bayswater	2	book now	£195	£205
2003/XP	2008 Aug 29 Fri	Southwark	4	book now	£224	£235
2003/XP	2008 Sep 3 Wed	Bloomsbury	6	book now	£214	£230
2003/XP	2008 Sep 5 Fri	Bayswater	4	book now	£195	£205
2003/XP	2008 Sep 10 Wed	Tooting	0	FULL
Full Schedule: See all 129 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: Merge documents

by - trainer Alan silver contributer [59 posts] (2008 May 18 Sun, 18:16) Reply

Don't merge them, consolidate them.

Use the Data|Consolidate menu.

· Advanced Excel Training - takes you to the next level
· Identifying Suitable Candidates For VBA For Excel Training
· Do You Really Need Excel VBA Training?
· How Excel Training Can Improve Your Company's Sales Process
· Advanced level training: Microsoft Excel and the Web

Please browse our web site to find out more about
excel 2003 visual basic intermediate course and other Microsoft training courses.

Excel tip:

Closing Multiple Open Worksheets At Once

When multiple Excel worksheets are opening, rather than performing a File > Close menu option multiple times, hold down the the SHIFT key and select the File > Close All menu option.

Close All menu option is only displayed when Shift key is down

View all Excel hints and tips