EXCEL merge data
Users questions: EXCEL table is a student information data (including student ID) now have a EXCEL sheet for students to research data (including identity cards and certificates), not every student has a certificate, how to order the chaos of the data plus the certificate to the student information data sheets
Experts answer: in two ways: 1 . The students to research information and data tables are tables and sort by ID, then paste. 2 small program using VBA code section to let the computer do it.