Results 1 to 4 of 4

Thread: Excel Spreadsheet question

  1. #1
    keyser_soze's Avatar Poster
    Join Date
    Dec 2002
    Location
    UK
    Age
    53
    Posts
    987
    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?

  2. Software & Hardware   -   #2
    kazaa2002's Avatar lost
    Join Date
    Dec 2003
    Location
    near oz
    Posts
    230
    Quote Originally Posted by 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?
    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?

    it is the small things that usually drive us mad

  3. Software & Hardware   -   #3
    BawA's Avatar FST Pioneer BT Rep: +1
    Join Date
    Jun 2003
    Location
    Some Where but not here
    Age
    41
    Posts
    4,213
    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.
    Last edited by bawa@Klite_user; 07-15-2005 at 05:51 AM.


    "You can be mad as a mad dog at the way things went; you can swear and curse the fates, but when it comes to the end, you have to let go"
    Benjamen button

  4. Software & Hardware   -   #4
    keyser_soze's Avatar Poster
    Join Date
    Dec 2002
    Location
    UK
    Age
    53
    Posts
    987
    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.

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •