# Too many sheets in one workbook

1. ## 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
freeecoom@yahoo.com

2. ## 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" <freeecoom.1vtc2a_1127480703.2543@excelforum-nospam.com> wrote
in message news:freeecoom.1vtc2a_1127480703.2543@excelforum-nospam.com...
>
> 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
> freeecoom@yahoo.com
>
>
> --
> freeecoom
> ------------------------------------------------------------------------
> freeecoom's Profile:
> http://www.excelforum.com/member.php...o&userid=27507
>

3. Dear Anne,
Thank you very much for your direction. Let me try it on.
Again, Thank you very much.
Peter

##### Users Browsing this Thread

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

#### 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