Merging information

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

Resolved · Low Priority · Version Standard

Merging information

Christof has attended:
Excel Advanced course

by - delegate Christof [5 posts] (2008 Feb 21 Thu, 17:33) Reply

I have two Excel files. Both are a list of booking information like reference name dates and room rate and so on.
One workbook has additional information how much the hotel charged for the booking. Both workbooks have the reference numbers of the booking. How can I get the charge information from one book merged into the other?

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Sep 8 Mon + 9 Tue	Bayswater	2	book now	£495	£495
2003	2008 Sep 18 Thu + 19 Fri	Bloomsbury	3	book now	£475	£495
2003	2008 Sep 25 Thu + 26 Fri	Southwark	5	book now	£450	£485
2003	2008 Oct 6 Mon + 7 Tue	Bayswater	5	book now	£450	£485
2007	2008 Oct 13 Mon + 14 Tue	Bayswater	7	book now	£345	£399
2003	2008 Oct 23 Thu + 24 Fri	Southwark	5	book now	£450	£485
Full Schedule: See all 44 Excel VBA course dates. Bookings currently available until 26th November 2009.

Also

by - delegate Christof [5 posts] (2008 Feb 28 Thu, 11:31) Reply

I found something that does the trick... however at a price... do you know a formula that could do the same?

http://www.ablebits.com/excel-lookup-tables/index.php

· Tools From Advanced Excel Courses: Goal Seek and Solver
· Tap the Power of Recorded Macros with MS Excel Courses
· How to Create Better Excel Spreadsheets: Part One
· Creating Smarter, Customized Invoices for your Small Business with Microsoft Excel
· Prepare for your MOS Certification with MS Excel Courses

Please browse our web site to find out more about
training courses in excel and other Microsoft training courses.

Excel tip:

Sorting data stored in rows

Primarily Excel is set up to sort data that is stored in columns rather than rows.

It is possible to get Excel to sort data stored in rows however.

Click in the row you want to sort, or select the cells in the rows you wish to sort.

Go to Data - Sort, then go to the Options button in the bottom left corner of the Sort dialogue box.

View all Excel hints and tips