Ok, here is what I'm trying to do.
I have a sheet for my monthly income / expenses. I have a column labeled "LOCATION" which bascially tells me where the money went to / came from. For example, if I paid $5.00 cash for Ihop then the location would be selected as "Wallet". If I paid with my Debit card, the location would be "Checking"
"Location" is column D, "Expense" (numeric figure) is column F.
I have a separate spreadsheet titled "Monthly Summary". This spreadsheet lists summary data for ALL months - January through December. There is a "beginning" column, which labels how much money I had in each location at the start of the month and an "ending" column, which shows how much money I have at the end of each month.
Now... the question.
At the moment, I add something to the expense / income sheet for today. Then I have to transfer over to the monthly sheet and adjust the "ending" number to reflect the purchase
I spent 7.75 at Mcdonalds using my checking account. I want Excel to take the 7.75 out of the ending column instead of me having to go do it again. How would I go about doing that?
THANKS!!
I have a sheet for my monthly income / expenses. I have a column labeled "LOCATION" which bascially tells me where the money went to / came from. For example, if I paid $5.00 cash for Ihop then the location would be selected as "Wallet". If I paid with my Debit card, the location would be "Checking"
"Location" is column D, "Expense" (numeric figure) is column F.
I have a separate spreadsheet titled "Monthly Summary". This spreadsheet lists summary data for ALL months - January through December. There is a "beginning" column, which labels how much money I had in each location at the start of the month and an "ending" column, which shows how much money I have at the end of each month.
Now... the question.
At the moment, I add something to the expense / income sheet for today. Then I have to transfer over to the monthly sheet and adjust the "ending" number to reflect the purchase
I spent 7.75 at Mcdonalds using my checking account. I want Excel to take the 7.75 out of the ending column instead of me having to go do it again. How would I go about doing that?
THANKS!!