Merge calendar in Excel

[vinaynaran]

Hi all,
This is my second reuest to all. Please help me to sort!!!

Please see attached files.
I have multiple files in same format and merge them in to single file like “Result.xls”
I have attached only two sample files (Keith Smale.xlsx" and "Martin Burton.xlsx")
and one result file (Result.xlsx).

I have used concatenate but it’s not very handy when you have so many files to merge.

Please help me!

Vinay

[vinaynaran]

This my second request. Please help me to sort!!!

[day92]

Vinaynaran,

This is going to take a sophisticated macro. I can create one that will merge on data into one sheet (lets say jan) but to have them merge into the respective month is going to be challenging.

[vinaynaran]

Hi there,
No problem if can merge only one sheet.
It will be very much appriciated if you could do.

Thanks
Vinay

[Marcol]

Try this for starters

With all 3 workbooks open

In Workbook Result in a new module

Please Login or Register  to view this content.

This will probably need some tweeking I'm on limited Internet access at the moment and do not have time at present to fully test it out.

Hope this helps.

[vinaynaran]

Dear Marcol,

Superb, Fantastic
There was a tiny error that I has corrected and it work perfectly fine.

Thank you so much that you have done great job.

Regards
Vinay