Sort multiple columns for same criteria

  • Thread starter Thread starter DEllis
  • Start date Start date
D

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.
 
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.
 
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
 
Back
Top