Rookie, right click on the sheet tab, select all sheets, make your changes,
all sheets will be changed, right click again, ungroup sheets

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Rookie000" wrote
in message ...

I will explain what I am trying to do, hopefully without confusing
anyone.....or myself:)

I want to create a templete. This templete will have
text,Numbers,Simple math functions,Cell formating. Then I want to
create a work book with 31 work sheets. Each work sheet will contain
the templete as previousley mentioned. My issue is that I need to
update the templete from time to time and I want the changes to the
templet to directley effect the 31 worksheets. How do i accomplish
this?


--
Rookie000
------------------------------------------------------------------------
Rookie000's Profile:
http://www.excelforum.com/member.php...o&userid=30487
View this thread: http://www.excelforum.com/showthread...hreadid=501414