Hi harpscardiff

See
http://www.rondebruin.nl/copy5.htm



--
Regards Ron de Bruin
http://www.rondebruin.nl


"harpscardiff" wrote in message
news:harpscardiff.22yw21_1139497206.8626@excelforu m-nospam.com...

hi,

I want to remove a row based on a cell, (P4).

So if p4="Verified Closed" Then
transfer row onto Closed tab.

This will be an ongoing thing, so if the code can find next empty row
and paste.

That would be cool...

Cheers.


--
harpscardiff
------------------------------------------------------------------------
harpscardiff's Profile: http://www.excelforum.com/member.php...o&userid=25960
View this thread: http://www.excelforum.com/showthread...hreadid=510577