Templete question...I hope there is an answer

R

Rookie000

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

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

Paul B

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
 
P

Paul B

Your welcome

--
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Is there an easy way to count when adjacent cells contain same data? 1
how to use codenames with an addin? 1
how do I generate lists in worksheets based on a master list works 10
use data on master worksheet for sorting 2
Excel Macro issue - How to copy and paste select rows from one sheet to another 2
Held with YTD formula 1
This is what I want to do... 1
Hide and Seek 4

Top