conditionaly compare rows of multiple sheets and paste the result

If sheet1 1st row is completely same with sheet5 1st row, sheet2 1st row  is completely same with sheet6 1st row,sheet3 1st row is completely same with sheet7 1st row, sheet4 1st row  is completely same with sheet8 1st row then put the result in sheet9 in b coloumn
we have to do the same with rest rows
Book2.xlsm
Avinash SinghAsked:
Who is Participating?
 
Bill PrewConnect With a Mentor Commented:
Can you provide some more meaningful test data covering the various cases you want to handle, and the expected outcome in sheet 9 for each of those?


»bp
0
 
Avinash SinghAuthor Commented:
thnx  Bill Prew sir for ur great guidance and giving ur precious time to this post
0
All Courses

From novice to tech pro — start learning today.