Need to copy rows in Sheet1 to different worksheets
 

Thank you so much......It worked perfectly.

Now all I need is for the format in'Sheet1' to also be copied i
subsequent worksheets.

What used to take me ages to do every month, I can now do immediately.

Thanks again.....Really appreciate it

--
minx200
-----------------------------------------------------------------------
minx2001's Profile: http://www.excelforum.com/member.php...fo&userid=1516
View this thread: http://www.excelforum.com/showthread.php?threadid=27176