Too many sheets in one workbook

  • Thread starter Thread starter freeecoom
  • Start date Start date
F

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)
 
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
 
Dear Anne,
Thank you very much for your direction. Let me try it on.
Again, Thank you very much.
Pete
 
Back
Top