Copy/paste means macro. If you don't want macros just use datafilterfilter
on y and America

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"deen" wrote in message
...
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