Thanks for the reply, i cant seem to get it to work tho , soon as i ru
it comes up with a box saying "Microsoft Visual Basic" a big red cros
and 400 and opens up a new workbook with sheet 2 info in it ?? am
doing something wrong ?

--
scottymellot
-----------------------------------------------------------------------
scottymelloty's Profile: http://www.excelforum.com/member.php...nfo&userid=380
View this thread: http://www.excelforum.com/showthread.php?threadid=27148