Hi all,

in sheet1 i have data like,

A B C D E
Name STD Roll Area Present
1 john 80 123 America Y

2 mike 90 456 Apac N

3 daniel 91 789 EMEA Y

4 barken 92 345 America Y

5 mark 93 765 apac N

6 brain 94 986 America N


Result i requried,

Sheet2 - Rename as America

first has check the column(E) its present(=Y) means and have to check
column(D) is equal is to (america) means entrie row should be copy and
paste in the sheet

A B C D E
Name STD Roll Area Present
1 john 80 123 America Y

2 barken 92 345 America Y

Note : result should come in continuely that means, result should be
come like 1row and 2row.....

In this case i requried only formula, kindly avoid macro.


Regards

Ahamed