Novice needs help could not find by searching

[Brodi]

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

 

[AlanY]

AlanY,

Thank you so much for your work. It does what I wanted. Now I just need to input my info and "TRY" to rearrange it just a bit to look like I want. Hopefully I can do that without screwing it up. Yes, I am making a backup copy.

I do have a question:
If I call Sheet2 January, can I copy it to sheet 3 and have that work as well without screwing things up? Will I need to make and adjustments? I am assuming that if I can make my minor formatting changes that I can copy sheet 2 over and over for each month.
Does this sound correct?

Thank you,

Brodi

not sure, atm Sheet 1 only pointed to Sheet2 for info and it wouldn't look for info in multiple sheets

 

[Brodi]

When I try to widen the width of the columns the numbers change all by themselves to different dates, amounts check#.

I'm trying to make sheet 2 look "KINDA" like this:

		DECEMBER					2016
		PROJECTED MONTHLY INCOME	Brodi's Income	$2,000					ACTUAL MONTHLY INCOME	Wife's Income	$0
		Extra income	$0	Total Monthly Income			Extra income	$0
		Total monthly income	$2,000	$2,000			Total monthly income	$0
						Total cash on hand
		First of Month	$2,000.00			Middle of Month
Due Date	Paid Date	HOUSING	Projected Cost	Actual Cost	Difference	Confirmation		Due Date	Paid Date	HOUSING	Projected Cost	Actual Cost	Difference	Confirmation
10/10/16		Lavon SUD	$45.58	$45.58	$0.00				12/14/16	ATT Phone	$293.18	$293.18	$0.00	59D7MYW9P03NCHY
10/4/16	12/14/16	Rise Broadband	$52.84	$52.84	$0.00	1391289		10/13/16	12/14/16	Reliant electric	$240.23	$240.23	$0.00	27142054
10/6/16	12/14/16	Kemper	$176.00	$176.00	$0.00	141316			12/14/16	Kohl's	$27.00	$27.00	$0.00	16121418613848
10/4/16	12/14/16	Ranchers and Farmers	$161.12	$161.12	$0.00	1214160023355				Groceries	$100.00	$100.00	$0.00
	12/14/16	BCBS	$218.61	$218.61	$0.00	82532388				Stephanie Hennigan	$0.00	$0.00	$0.00
		Groceries	$100.00	$100.00	$0.00					Lucy Medications	$50.00	$50.00	$0.00
		Dr. Silav	$0.00	$0.00	$0.00					Dr. Silav	$0.00	$0.00	$0.00
		Bob's Meds	$50.00	$50.00	$0.00				12/14/16	AARP Life ins	$39.29	$39.29	$0.00	2.47112E+11
					$0.00			16th		Homeland	$18.00	$0.00	$18.00
										AARP 3 years	$43.00	$43.00	$0.00
		Total	$804.15	$804.15	$0.00					Total	$810.70	$792.70	$18.00
		Total Due First of Month		$804.15					Total Due Middle of Month	$810.70
		Paid First of Month		$804.15					Paid Middle of Month		$792.70
		Left to pay First of Month		$0.00					Left to pay Middle of Month	$18.00
						Month Total Expenses	$1,614.85

<tbody>
</tbody>

This stuff initiates a problem for me called a STUPID ATTACK.

Also trying to add rows at the top of sheet1 to add general info there.

Thanks again.

Brodi