hi,i’m so sorry for having to many issues.
there is two problems i have met:
1).if i don’t know the sheet name (only one sheet in the excel),how can i copy the sheet to another excel;
2) copy column “SUBJECT” in course.xlsx to student.xlsx based on column “ID”,like the following image.student.xlsx (8.7 KB)
course.xlsx (8.6 KB)