Hi all,

Plz do needfully for the subjected..

For Eg..

Sheet1 having All subjects Marks of Stud1
Sheet2 having All subjects Marks of Stud2
Sheet3 having All subjects Marks of Stud3
Sheet4 having All subjects Marks of Stud4
Sheet5 having All subjects Marks of Stud5

now in Sheet6, we have to find the Max(mark of sub1 from all sheets) and so..

Plz help, how to..

Thanks

Krishna