Try this
http://www.rondebruin.nl/copy5.htm

Below the first macro you can read how to do it manual

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Memphus01" wrote in message ...
How can I create a statement that will select all rows on sheet 1 that have
Value "X" (text) in Column B and then paste into Sheet 2, A2?