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.
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
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
