Too many sheets in one workbook

[freeecoom]

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
(e-mail address removed)

 

[Anne Troy]

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/sum_the_same_cell_in_multiple_microsoft_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]

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