Printable View
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,Quote:
Originally Posted by keyser_soze
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?
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.
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.