Hello all,
I just signed up for yor forum to learn more about Excel. I have the latest version of MS Office.
I am horrible with formulas, don't understand them, can't figure them out when laid out in front of me (but if you need a welder, I'm your guy).
So here we go:
New spreadsheet
Sheet 1
Check register
I have the makings of a regluar check register with auto math functions similar to the many on the web.
Sheet 2
Bill pay sheet
I have my bills listed with their amounts paid and all that similar to below:
[Date due]....[Date paid] [Description] [Amount] [Paid Y/N]...[Conformation #]
10/10/16........10/15/16....Internet.......$40.05..........Y............12345678
10/13/16........10/15/16....1999 Ford.....$300............N
And so on.....
I have an identical sheet for each month of the year
Here is my question:
How do I Enter the information into sheet 2 (in any order) and have that information automatically enter on the next available line in the check register (and do the math). This could be triggered by checking a box or placing a Y in the PAID column. I do not get my bills in the order they are de so I may want to pay a bill at the bottom of the list before one at the top oif the list.
I want to pay the bills for January on sheet 2 and automatically have the register add the info and do the math without me ever changing to the page.
I will be able to populate a cell in sheet 2 with my CURRENT balance as I pay bills so I know what is available.
I really hope this makes sense to those here. Hopefully I am not asking for something that cannot be done. And please, do not spend your entire weekend trying to solve my problem, it is MY problem.
It is difficult to describe as it is in my head but I think I got the point across.
I have not created sheet 2 yet as I don't want to have to change it later so I can do whatever I need to make it work (Except make it work myself).
I hope this is simple for those here and someone can explain it in a way that I will understand it. I am computer challenged and was hoping for a cut and paste answer somewhere on the web or a pre-made spreadsheet that did what I want but could not find either so now need to try to understand it in an explained version if anyone here has the answer I am searching for.
If this has been answered before and I did not find it in search, I appologize, please refer me to the thread.
Thanks to all for sharing their knowledge with those that do not have it.
Brodi
I just signed up for yor forum to learn more about Excel. I have the latest version of MS Office.
I am horrible with formulas, don't understand them, can't figure them out when laid out in front of me (but if you need a welder, I'm your guy).
So here we go:
New spreadsheet
Sheet 1
Check register
I have the makings of a regluar check register with auto math functions similar to the many on the web.
Sheet 2
Bill pay sheet
I have my bills listed with their amounts paid and all that similar to below:
[Date due]....[Date paid] [Description] [Amount] [Paid Y/N]...[Conformation #]
10/10/16........10/15/16....Internet.......$40.05..........Y............12345678
10/13/16........10/15/16....1999 Ford.....$300............N
And so on.....
I have an identical sheet for each month of the year
Here is my question:
How do I Enter the information into sheet 2 (in any order) and have that information automatically enter on the next available line in the check register (and do the math). This could be triggered by checking a box or placing a Y in the PAID column. I do not get my bills in the order they are de so I may want to pay a bill at the bottom of the list before one at the top oif the list.
I want to pay the bills for January on sheet 2 and automatically have the register add the info and do the math without me ever changing to the page.
I will be able to populate a cell in sheet 2 with my CURRENT balance as I pay bills so I know what is available.
I really hope this makes sense to those here. Hopefully I am not asking for something that cannot be done. And please, do not spend your entire weekend trying to solve my problem, it is MY problem.
It is difficult to describe as it is in my head but I think I got the point across.
I have not created sheet 2 yet as I don't want to have to change it later so I can do whatever I need to make it work (Except make it work myself).
I hope this is simple for those here and someone can explain it in a way that I will understand it. I am computer challenged and was hoping for a cut and paste answer somewhere on the web or a pre-made spreadsheet that did what I want but could not find either so now need to try to understand it in an explained version if anyone here has the answer I am searching for.
If this has been answered before and I did not find it in search, I appologize, please refer me to the thread.
Thanks to all for sharing their knowledge with those that do not have it.
Brodi