Hi guys,

I'm extremely new to macro but I'm thinking macro should be able to do this:-

I got 12 excel files, let's name it A.xlsx, B.xlsx, and so on, and each located at different directory:

For example:

C:\Desktop\New Folder 1\A.xlsx
C:\Desktop\New Folder 2\B.xlsx
C:\Desktop\New Folder 3\C.xlsx
C:\Desktop\New Folder 4\D.xlsx
C:\Desktop\New Folder 5\E.xlsx
C:\Desktop\New Folder 6\F.xlsx
C:\Desktop\New Folder 7\G.xlsx
C:\Desktop\New Folder 8\H.xlsx
C:\Desktop\New Folder 9\I.xlsx
C:\Desktop\New Folder 10\J.xlsx
C:\Desktop\New Folder 11\K.xlsx
C:\Desktop\New Folder 12\L.xlsx

All the excel files, from A.xlsx to L.xlsx, I want to copy cell A397:M403 and paste into a spreadsheet

Note that A397:L397 are merged cell, the rest are no-merge cell

For file A.xlsx to F.xlsx, I want it to be copy and paste into new spreadsheet on the left hand, and for file G.xlsx to L.xlsx, I want it to be copy and paste on the right hand side, so that I can view side by side as per the draft below:-

A.xlsx G.xlsx
A397:M403 A397:M403

B.xlsx H.xlsx
A397:M403 A397:M403

C.xlsx I.xlsx
A397:M403 A397:M403

D.xlsx J.xlsx
A397:M403 A397:M403

E.xlsx K.xlsx
A397:M403 A397:M403

F.xlsx L.xlsx
A397:M403 A397:M403

Currently it's too manual to open one by one and copy paste in a monthly basis
And for some reason, when i paste in formulae, next month when I open the file, the formulae are in chaos before I replace the formulae with new file (due to new directory...)

Hope to hear soon from macro-expert here....

Let me know if there's enquiry..

Thanks

regards
cks1026