Why not just use datafilterautofilterfilter on gocopypasteunfilter
Record a macro desired

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"muddan madhu" wrote in message
...
Suppose I have some data in Column A to Column D
Column A - names
Column B - score
Column C - result
Column D - stats

There are 100 names in a list
If the column d , row 2 has the word "go" then it should copy entire
row and paste in a new workbook.
If row 3 has the word "no" then it should not copy , move to next
row ..

What code should i write to execute the above condition...

Thanks in advance......