Thanks tom
this is almost what I am looking for hoevever it is putting it in the
wrong sheet. I Need it in worksheet (Recap Report) not Data.
--
parteegolfer
------------------------------------------------------------------------
parteegolfer's Profile:
http://www.excelforum.com/member.php...o&userid=31951
View this thread:
http://www.excelforum.com/showthread...hreadid=526278