Forum Discussion
Excel - Entering consecutive months in different sheets
May I ask you a question? I'd like to know why you have a separate sheet for each month...often that's done because we approach the task as if Excel really was no more than a little more automated green ledger sheet--i.e., we use it to add and subtract to make keeping (for example) track of expenses on a monthly basis a bit easier.
In fact, if that's the kind of thinking behind your use, you could benefit from separating the input of expenses (by date, payee, budget category, amount) from a nice monthly report (the output).
That's just an example....and it's why I'm asking. There may be an entirely legitimate reason, but often it's a failure to understand how Excel can work to produce a nice report from a single input sheet covering all months (even multiple years).