I am working with two excel files.One is Master Data file.
I need to map data from master excel file to Another file.
In master data file , there are Multiple Columns like Student Name , MarksDailyReport.xlsx (9.1 KB)
MasterSheet.xlsx (8.1 KB)
In other sheet , I have Student Name column with Data and Marks column is without data for particular student.
Problem is , In master excel file Student Name And Marks columns Having data for 10 students.But for another excel file Marks Column , I need data for Random 5 students.
Other sheet having 5 random Student names , here i need to Map Marks column data from master for particular student.