98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » excel training onsite - Excel - merging spreadsheets
excel training onsite - Excel - merging spreadsheets
Resolved · Low Priority · Version Standard
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
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 tip:Change the Print button so it brings up the Print dialogue boxIf you want to bring up the Print dialogue box to check your print settings when you hit the Print button, do the following: |