Sort multiple columns for same criteria

[DEllis]

Maybe not the right subject line. What I have are 4 columns that have been
populated by a macro. What I now want to do is take those 4 columns extract
any rows with percentages that are -50% or less and any that are 100% or
more. Can this be done. I want to then put the rows extracted and put them
on a separate worksheet, removing them from the source worksheet.

 

[Don Guillett]

If desired, send your file to my address below along with this msg and
a clear explanation of what you want and before/after examples.

 

[YESHWANT JOSHI]

have u tried applying autofilter thru which u can get the data u wanted.
just copy the same and take it to another sheet/book for your working.

click yes below, if it works