How to get a summary of total expenses

With Power Query

Please Login or Register  to view this content.

You will need to change the source to the path on your PC to the file. You have only posted one record per expense item. How do you propose to show a result for more than one record per expense. Your example does not present what I presume to be a realistic example of your needs. Does your sample actually present a realistic example of your actual data.

I suspected as such, but with additional expenses, how do you want the result to look. Summarized? Not? Show us a sample with multiple expenses and how you want the result to look. I think you missed my point in my earlier question.

Provide a mocked up sample, as requested.

How is this going to "Auto" update the "Total Expenses Summary"?
As I see, this works only if I enter "a date" in to a cell in the column A, and "description" in to the column B..
If I have to enter a date and description in to cells in the summary sheet to get the summary of any expense, I could do it just by copying the same information from the expenses sheet itself without any formula...or did I miss anything here?

What I exactly need is to get the "Total Expenses" summary automatically updated when I keep entering expenses in to individual expenses sheets.... In other words, The expense should appear on the "Total Expenses" sheet with "date, description" and "amount" automatically when that particular expense is entered into its own individual expense sheet. Hope this is clear to you...

This can be automated using VBA: this requires adding (the same ) "event" code to each expense sheet which will, when data is added to any of the expense sheets, invoke a separate macro to recalculate "Total Expenses Summary".

I will ask again that you provide sample data with more than one item in your source data so that it can be summarized by month. One item is not sufficient to demonstrate this. If you are unwilling to provide this then I will leave this issue for you and others to resolve.

Sample event code:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[I note you appear to manually enter data twice rather assign the "second" occurence by formula. Example is "FOOD" column E and I.]

Based on last MANUAL input on a given expense sheet and ALL expense amount to be in column I. In TAXES amount iis column C not I

If the latter is not acceptable then code will need to be changed to have expense sheet specific columns

Named range "Expense_Sheets" has required sheet names

There are GPT extensions that yu can install on top of your Excel and ask a question just like this in Excel and it will make all work for you!
Saves a lot of time for me! Good Luck!

Another version which updates the "Total Expenses" with single additions from each expense sheet.

Example is in sheet ""Fuel-Anuruddha".

Please Login or Register  to view this content.

Please Login or Register  to view this content.