Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Moving sheets

  1. #1
    New Member
    Join Date
    Jan 2002
    Location
    Canada
    Posts
    42
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have a workbook with about 25 sheets. The first sheet is a Summary of all others and has many formulas that refer to each sheet. I would like to move the placement of one of the sheets to be the second one. Will this mess up any of the formulas in the Summary sheet?

    I'm thinking of when you add a line or column in the wrong place, it will mess up formulas. I can't see this happening when moving the placement of sheets but just want to be sure.

  2. #2
    Legend NateO's Avatar
    Join Date
    Feb 2002
    Location
    Minneapolis, Mn, USA
    Posts
    9,700
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Won't hurt, move away eh (I'm inclined to say 'eh' as I was born in Ontario).

    _________________
    Cheers, NateO

    [ This Message was edited by: NateO on 2002-05-11 11:43 ]

  3. #3
    New Member
    Join Date
    Jan 2002
    Location
    Canada
    Posts
    42
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Our one exclusive identity isn't it. I ran off a copy of the summary sheet first and the figures all seem fine. Thanks for the confidence builder Nat. Small things mean alot eh.

  4. #4
    New Member
    Join Date
    Jan 2002
    Location
    Canada
    Posts
    42
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Oops! I did have to change one thing. My formula on the summary page was
    =SUM('sheet1:sheet25'!C48)
    In moving a sheet called misc to the front of the line, I had to change the beginning of the formula to:
    =SUM('misc:sheet25'!C48)

    So it does kind of act like adding a row/column in that it doesn't pick it up if it's at the very beginning or end of the formula.

    Just thought I would add this in case another newbie tries it.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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