Comapre excel sheet and generate result

saritha - Nov 27, 2009 at 04:44 AM
 saritha - Dec 10, 2009 at 12:16 AM
I have an excel workbook contains students details like name , Roll no, address,phone numbers etc. and another
book contains only Name, Roll number and fee details. I want to compare these two sheets and generate an excel sheet which contains the names and roll no of students those who didn't pay fees.

Please help.


1 reply

venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Nov 28, 2009 at 08:01 PM
the configuration of the two sheets is not known. anyhow you can try autofitler -custom
normal two worksheets, sheet1 contains Name, roll no, address ..etc (almost 1000 lines ). second sheet contains same students fee submission details.

I just wanted to compare these two sheets.

result data sheet = data in sheet1 - data in sheet2

intention ..... I want to generate a workbooks containing list of students those who didn't paid the fees.

can u help, I am a beginner in excel.

thanks in advance