I need 1 option . How to do it i don't know. Please help.
I have 2 sheets.
First sheet contains some datas. In Cell A1 S.No, B1 Name, C1 Date of birth, D1 Age, E1 School name. And Assume A2 to E100 contains some datas.
I need all list one by one (rows) that contains age is equal to 5 in Sheet2.
Please don't suggest FILTETR Option.
Please help as soon as possible.
Thanks in Advanceš