Use the filter (DataFilterAutofilter) to make the selection, then just
copy and paste the visible rows.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"sotiris_s" wrote in message
...
Hello,
i have a worksheet with data (numeric,text) from the A collum up to the AH
each row is a new data entry, (sometimes i have up to 2500 entries) so
i need to find out, how i can with some criteria such as <if the value at
the cullum V is above 110 for example then give me all the row in a new
worksheet inside the same xls file. It is tricky for me to do that... i
have
good hadling of the if command and the option to make an auto filter is
not
the goal.... the logic is that i want to do that in a kind of auto...
thank you for your help in advance
Sotiris S