Hi all. So if the Trainee’s name from CourseName2.xlsx matches with the Trainee’s name in Filtered2.xlsx, the program will extract the Course and year from Filtered2.xlsx and paste into CourseName2.xlsx in their respective Trainee’s name.
Here are the 2 excel files. Please provide with workflow. Thank you!