Expenses Tracking Formula

[Phillip Walters]

Good Morning.

i am putting together a very simple profit and loss spreadsheet. this shows total product sales and various tabs for different outgoings.

Only 2 people are involved in this (MP & PW)

For each tab of outgoings there is a column which shows who has purchased a particular item.

For example the tab Red Grape Juice shows that MP spent SR554 within February.

I would like, if possible, to capture the expenses incurred by each person in the "Expenses Owed" Tab and to automatically populate when an entry is made on any of the out goings tabs

Red Grape Juice
White Grape Juice
Jam
Pepsi-7up
Grapes
Yeast
Misc

the idea being that if there is an entry in any of the above tabs showing MP or PW within the purchased by column, the expenses tab will be populated within the relevant table.

Thank you all in advance for your help.

[AliGW]

Administrative Note:

We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

[Phillip Walters]

can you see if the edit is ok?

[Phillip Walters]

hi Admin

can you confirm this post is accepted please

[Phillip Walters]

thanks for your help!

[AliGW]

Title is fine, but your explanation of what you want and sample workbook devoid of any indication of expectation are what are preventing you from getting help - sorry. No idea what you want!