There are 2 files
- Master file in which all master data is stored
- sample file is used to add new data.
here I have some data in both sheet, some of data is same in both sheet.
Now here it compare both sheet if data of both the sheet is match then it show status (“Student Exist”) in status column in sample sheet.
if not match show the status (“New Student”) & then copy that data in master sheet
and there is also a student id column which is also increase with the adding data.
and please do it in simple way because I am a beginner.
output.xlsx (12.5 KB)