Hello all,
I am working on my personal budget on excel and have reached an issue. I have it to where i can input all my data using a form. This form contains (items, price, date and confirmation number). all this populates on a separate "payments" sheet once its saved. In addition to the payment sheet i have a yearly sheet as well "2016". In this sheet each of the items (car, rent, phone, etc...) are listed and the 12 months of the year. My end goal here is when I use my form to enter the payment info it also recognizes the item and month and places the amount in the correct spot.
So for example I input my car payment for June at $400.00. All the information is entered and then saved in the "payments" sheet. What I want to happen in addition to this is that amount ($400.00) also go into the "2016" sheet in the appropriate column based on the item and the month.
I have attached some screenshots of what im working with. The first screenshot is the main page with the form. The second screenshot is the payments sheet, where the data saves to. the third sheet is where I want the amount to automatically populate, based on the item and month entered.
Any help offered is greatly appreciated!
Bookmarks