Forum Discussion
significant shortcoming of Money in Excel
mathetes , thank you for the feedback. If you don't mind I forwarded the link on your post to MVP community.
I don't mind. In fact, I'm glad you did it. I am curious about the connection between the MVP community and Money In Excel.
I had searched for a way to give the feedback directly (I really did think the Expense Categories" area was woefully deficient of creative thought on how such things could be organized for greater reporting utility. I have created my own, since the advent of Dynamic Arrays and their connection with Data Validation, categories and sub-categories that can grow when needed)....
Anyway, thank you!!
Are you saying you have a work around to the Expense Category deficiencies in MIE?
That's one of my main problems. Let me know if you can help.
You wrote:
Are you saying you have a work around to the Expense Category deficiencies in MIE?
That's one of my main problems. Let me know if you can help.
I had created my own budget and expense tracking spreadsheet, and in it I have categories and sub-categories. I take advantage of the newest version of Excel, with the Dynamic Array functions... notably UNIQUE, FILTER, SORT... I could make a copy of that sheet (it's on a tab of its own in my workbook). But I have no idea whether it would work with MIE. And I don't think it'd be all that easy to extend theirs. They just did a poor (as in short-sighted) job of coming up with that one aspect of what otherwise looks like a pretty useful app.
I do a lot of the same things they do; I just have to go download from my credit card and bank accounts rather than link directly through that service they use, but since my main account is with Fidelity and I have their dual-factor (Symantec) log-in, MIE is of no use to me anyway.