training excel vba - Merge

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

Resolved · Low Priority · Version Standard

Merge

by - felicia [guest] (2006 Nov 17 Fri, 22:38) Reply

How do I merge information contained in sheet 1 and sheet 2 into one document onto sheet 3.

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

RE: merge

by - trainer Richard platinum contributer [785 posts] (2006 Nov 20 Mon, 12:58) Reply

Depending on the format, layout and content of the data you could use several techiniques:

1.
If the data is structured identically on sheet 1 and 2, then use CONSOLIDATE RANGES

2.
If the data is differently structured, then you may need to design a more tailored approach using other skills like 3-D formulas, or custom formulae.

I recommend reading through the Excel HELP file, specifically "About consolidating data", which wil detail the various ways you can approach your challenge.

Once you have done so, let us know if you find some next steps to work on.

· Customized Financial Excel Courses in London
· Fun Things I've Done With Excel
· How to Create Better Excel Spreadsheets: Part Two
· Microsoft Excel Features and Functions for Accountants
· How to Create Better Excel Spreadsheets: Part Three

Excel tip:

Editing Formulas in Excel Cells

Although people like to edit a formula in the Formula bar, you can also edit a formula in the cell.

To do this select the cell and press "F2". This puts Excel into Edit mode, and you can move around in the cell and make any necessary changes.

Double-clicking the cell also puts Excel in Edit mode.

View all Excel hints and tips