I have two folders folder is the folder A and B, A and B, respectively, inside have file 1 to 10, the file name is the same, each file is only one sheet table and the surface is consistent, but inside the content and format is different, want to send the file with the same first merged into an EXCEL book and this book contains two sheet table, respectively is A and B in the file

CodePudding user response:

In Excel macro recording, the "consolidation" process operation manual again, has a code,

CodePudding user response:

Began keeping records in Excel macro, manual, complete the required function end record macros, press Alt + F11 key, check just record macro corresponding VBA code,