Oops...may have read your question too fast.

To copy 1 sheet to many, copy what you want, then hold CTRL and click
on the destination sheets and paste your data. Be sure to click on a
non-selected sheet when your done or any subsequent changes you make on
a highlighted sheet will be made to all sheets you have highlighted.

Hope it helps...


--
Phillycheese5
------------------------------------------------------------------------
Phillycheese5's Profile: http://www.excelforum.com/member.php...o&userid=24196
View this thread: http://www.excelforum.com/showthread...hreadid=390685