Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training onsite - Excel - merging spreadsheets
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
excel training onsite - Excel - merging spreadsheets
Resolved · Low Priority · Version Standard
Reply Thu 2 Aug 2007, 17:29Delegate Anne said...
Anne has attended:
Excel Introduction course
Excel Intermediate course
Excel Advanced course
Excel VBA Intro Intermediate course
Excel Advanced course
Excel - merging spreadsheets
I have a large number of excel spreadsheets and i want to merge them into one spreadsheet.
Is this possible.
Anne.
For upcoming training course dates see: Pricing & availability
RE: Excel - merging spreadsheets
Hi Anne
The key point to check is: do your spreadsheets share the same structure? i.e: Column headers, row names etc.
If they do, then there are various ways to consolidate their data onto a single sheet, by lookups, pivot tables, simple mulitple-sheet linking etc.
The methods/tools you use will be specific to your situation. Please note that we assist our delegates who have attended our standard training courses with more bespoke and consultative solutions, which may be the case here.
Regards
Jacob
Reply Wed 8 Aug 2007, 15:02Delegate Anne said...
RE: Excel - merging spreadsheets
Thanks for your reply.
i am booked onto the Advanced Excel next week and then the Excel VBA in September.
Would this query be covered in any of these courses?
as what i what is specific to my needs would it be possible to offer a 1 to 1 training day in my office?
if so what would be the cost and availability - my office is in New Malden.
I look forward to hearing from you.
Thanks.
Anne.
RE: Excel - merging spreadsheets
Hi Anne
I would certainly suggest that the attendance of your booked courses will help you view your work objectives more clearly though hard to promise they will give you a direct solution.
However after your training on MS Excel to advanced level and our 2 days Excel VBA course you will be in a better position to specify the work that you require.
For consultancy work with clients, our rates start from
Reply Thu 9 Aug 2007, 15:27Delegate Anne said...
RE: Excel - merging spreadsheets
Hi Jacob,
i will review the situation once i have completed both excel courses.
thank you for your help.
Regards
Anne.
|