Thanks for the reply both!, they both worked well.....for my application
Dave's code with "No Match Found" served a purpose, only one thing
missing is when the sheets are moved i need the originals to be
deleted!

Oh and being greedy........is it possible to supress the code break if
the filename already exists?

Once again thank you both...

Regards,
Simon


--
Simon Lloyd
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.excelforum.com/member.php...fo&userid=6708
View this thread: http://www.excelforum.com/showthread...hreadid=547267