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.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

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

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

"DEllis" wrote:

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.