+ Reply to Thread
Results 1 to 3 of 3

Too many sheets in one workbook

  1. #1
    Registered User
    Join Date
    09-23-2005
    Posts
    6

    Too many sheets in one workbook

    Too many sheets in one workbook
    Hello everyone,
    MY name is Peter. I created 30 or 31 sheets in a workbook to represent 30 days in a month and another sheet to sum the amount of spending and receiving money in that month.

    In each sheet, there are many rows for items. Every day, I enter data onto it. I mean that there is so much data in one sheet that would increase the size of this workbook. And after around 10 days, it took me a long time to open this workbook.

    I am wondering if there are some ways to divide this workbook into 2 or 3 parts, but the sum sheet will get all the total amount of 30 sheets. If it is possible, please show me how?. OR, if you have a better way to solve this problem, please direct me. It would be greatly appreciated!
    I am looking forward to hearing from you.
    Regards,
    Peter
    [email protected]

  2. #2
    Anne Troy
    Guest

    Re: Too many sheets in one workbook

    Hi, Peter. If this were me...
    For my Daily sheets: I would put my column headings in Row 2. I would put my
    totals in Row 1 (i.e., =Sum(a3:a65536)
    Then, I would use the method described here to create a summary sheet:
    http://www.officearticles.com/excel/...worksheets.htm
    And my summary sheet would show one row for each day, perhaps again with the
    totals in Row 1 to reduce scrolling.
    Now, what you COULD do, if it's not required for you to be able to change
    the daily worksheets, is just keep a week or so of detail. Imagine this:
    It's the 15th of the month. You have sheets for 8 through 15 with detail.
    You take the totals rows from 1 through 7 and copy, then edit, paste
    special, values, copy those worksheets to some other long-term storage
    workbook, while still maintaining your monthly totals. This could all be
    automated, of course.
    Alternatively, you could do what you should probably be doing... use Access.
    It's probably not nearly as hard as you might think, and don't say no
    just 'cause you don't know Access. You'd likely find the learning curve not
    to difficult.
    ************
    Anne Troy
    www.OfficeArticles.com

    "freeecoom" <[email protected]> wrote
    in message news:[email protected]...
    >
    > Too many sheets in one workbook
    > Hello everyone,
    > MY name is Peter. I created 30 or 31 sheets in a workbook to represent
    > 30 days in a month and another sheet to sum the amount of spending and
    > receiving money in that month.
    >
    > In each sheet, there are many rows for items. Every day, I enter data
    > onto it. I mean that there is so much data in one sheet that would
    > increase the size of this workbook. And after around 10 days, it took
    > me a long time to open this workbook.
    >
    > I am wondering if there are some ways to divide this workbook into 2 or
    > 3 parts, but the sum sheet will get all the total amount of 30 sheets.
    > If it is possible, please show me how?. OR, if you have a better way
    > to solve this problem, please direct me. It would be greatly
    > appreciated!
    > I am looking forward to hearing from you.
    > Regards,
    > Peter
    > [email protected]
    >
    >
    > --
    > freeecoom
    > ------------------------------------------------------------------------
    > freeecoom's Profile:
    > http://www.excelforum.com/member.php...o&userid=27507
    > View this thread: http://www.excelforum.com/showthread...hreadid=470204
    >




  3. #3
    Registered User
    Join Date
    09-23-2005
    Posts
    6
    Dear Anne,
    Thank you very much for your direction. Let me try it on.
    Again, Thank you very much.
    Peter

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1