I have a large number of excel spreadsheets and i want to merge them into one spreadsheet.

Is this possible.

Anne.

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

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.

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 £650 per day for an agreed scope of work.

Regards

Jacob

Hi Jacob,

i will review the situation once i have completed both excel courses.

thank you for your help.

Regards

Anne.