Hi Gary

Thanks for your script, it sort of works, it certainly recognises that
there are 8 rows that meet this criteria in my test data, but it is
copying Row 1 eight times to sheet 2 instead of the row that the 1
resides in

Are you able to help ?

Thanks

Regards

Karen


--
ksp
------------------------------------------------------------------------
ksp's Profile: http://www.excelforum.com/member.php...fo&userid=6267
View this thread: http://www.excelforum.com/showthread...hreadid=488087