Through the import health according to table 2, realize the following functions: A need to import table of contents for the A11: E14 (such as A table in the D: \ Test folder below), table 1 A - E for table 2 E: H column, the import of table 2, from the fifth line to insert the import, and according to the personal information of table 1 above, list all the import table 2 A - D corresponding person information (such as departments, staff number, name, date), thank you!

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,