Consolidation

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

Resolved · Low Priority · Version 2003

Consolidation

Sonia has attended:
Excel Intermediate course

by - delegate Sonia [1 post] (2008 May 20 Tue, 16:04) Reply

How would I consolidate multiple spreadsheets with using some information from one spreadsheet and some from another.

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 25 Tue + 26 Wed	Bayswater	6	book now	£455	£515
2003	2008 Nov 26 Wed + 27 Thu	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 1 Mon + 2 Tue	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 4 Thu + 5 Fri	Bloomsbury	5	book now	£450	£485
2007	2008 Dec 11 Thu + 12 Fri	Bayswater	5	book now	£475	£515
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	6	book now	£450	£475
Full Schedule: See all 37 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Consolidation

by - trainer Stephen gold contributer [369 posts] (2008 May 21 Wed, 11:44) Reply

Hi Sonya

Thank you for your question

Could you clarify your requirements for me? Specifically is the data on eached sheet laid it in the same structure. For example are you trying to consolidate the values from multiple copies of the same table, located in different sheets in the same work book

Thanks

Stephen

· Microsoft Office and the Small Business: Part 1 Excel
· Why Should I Learn Visual Basic in Excel?
· Crazy Things People Have Done With Excel
· Microsoft Excel Courses Teach Advanced Macro Techniques
· Improve Performance Of Your Excel Macros

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

Excel tip:

Using Alt in Save Dialog Box

When you are saving (or opening) a file, try these;
(Note the numbers are on the keyboard not the numeric keypad)
1. Go to previous folder Alt+1
2. Go up one folder level Alt+2
3. Search the Web Alt+3
4. Delete selected file Alt+4 or Delete
5. Create a new folder Alt+5
6. Cycle through all views Alt+6 repeatedly
7. Display the Tools menu Alt+7

View all Excel hints and tips