have you tried the macro recorder?
You may have to do it one piece at a time and then put it together,
somethings can't be done on the macro recorder and when you come to
that spot,
ask if anyone has a vba code to do such and such, anyway
try the macro recorder, your own success will be very rewarding
--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile:
http://www.excelforum.com/member.php...o&userid=31708
View this thread:
http://www.excelforum.com/showthread...hreadid=542712