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]
Bookmarks