Excel Spreadsheet question

[keyser_soze]

I'm trying to make a spreadsheet that rolls over, for instance I've already made a template sheet,sorted my borders and entered my autosums but what I need it to do is carry the template on to the following sheets then only print off the needed sheets,any ideas?

[kazaa2002]

I'm trying to make a spreadsheet that rolls over, for instance I've already made a template sheet,sorted my borders and entered my autosums but what I need it to do is carry the template on to the following sheets then only print off the needed sheets,any ideas?

open your spreadsheet,
click on edit
click on move or copy
highlight move to end
check box...create a copy
click ok

this will give a exact copy of your first sheet(will carry your template)
you can link the two sheets by refering newly created to the original
by name see my formula which I created in cell c13 on sheet4

=sum(sheet1!b13)+sheet2!b13

this formula will go to first sheet
and then the 2nd sheet and take whatever figure is there
and place total in sheet4 c13

printing:
go to file
select print
go section that is labeled ...print what...
if you select entire workbook
it will print all 4 sheets
if you select ..active sheet it will only print sheet you are
working on.

does this answer your question?

[BawA]

u want to keep one orginal sheet and use other seets as copy, right?
then do what above posts says or...
at the bottom of the page u can see "sheet 1,2,3" right click on the orginal and select move or copy, highlight "move to the end" and check "make a copy" and ull get exact copy of the sheet.
then u can lock the orginal and u can apply some ranges to it so only thoes fields u want can be edited. like u can lock the farmula area and only live the fields u want to be edited open.
example: u have...
A1,B1 and C1
u can lock C1 for the formula result and keep open A1 and B1(A1:B1=C1), like this C1 will be updated with the result if A1 and B1 gets value and returns to orginal value when A1 and B1 gets cleared.
ehhh i know this is not what uve asked but i thought it be usefull, its good if u dont want to keep writing formula again and again if u edit the field by mistake.
so if u want to know how to lock reply.

[keyser_soze]

cheer that would be handy, I'm at working trying it out now I'll post an image of what I'm trying to achieve.