Auto amounts on a certain date

[Wens]

Hi, i am after some help
Bare with me i'll explain what i want to best that i can
I am setting up spending worksheets i want to fill regular payments on regular dates i have done alot of searching and cant quite find what i need to do to make it happen i think it would have to do with conditional formatting and formulas
2 different thing i would like to do is
- with every date listed in this worksheet on the 23rd of the month i want the cell in column 'bills' for the amount of $500 to appear
-not sure if this one is possible and dont mind setting at the begining of each month it is a different set up but in a 'rent' table i want to put the dates in but only fill the cell next to it once its that date
if you can help me out that would be fatastic, thanks in advance

 

[Smitty]

Welcome to the Board!

If you follow the HTML Maker link in my sig you'll be able to post a shot of your sheet. That will give us a bit more to go on...

 

[Wens]

Im using Excel 2007 and ive added the add in in the excel options but its not showing up as a menu anywhere when i select the area that i want to show?

 

[Smitty]

Look in the Ribbon for the Add-Ins menu.

From there you'll see an HTML Maker item with several options. You might need to experiment with it a bit to get the display you want, and you don't get a notice that the screen shot has been converted (we need to fix that), so just come back to your post and use CTRL+V to paste your code into your next post. As soon as you submit it the board software will convert the code to an image.

 

[Wens]

i found a different one that seemed to work while i was waiting, does this help to explain what im after? the amounts that are there i want to show up once it is the date that they are next too? sorry if im not making sense

Sheet1


<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Calibri,Arial; FONT-SIZE: 11pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 90px"><COL style="WIDTH: 20px"><COL style="WIDTH: 94px"><COL style="WIDTH: 92px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 95px"><COL style="WIDTH: 100px"><COL style="WIDTH: 64px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD></TD><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD><TD>F</TD><TD>G</TD><TD>H</TD><TD>I</TD><TD>J</TD><TD>K</TD><TD>L</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">1</TD><TD style="FONT-WEIGHT: bold"></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="FONT-WEIGHT: bold"></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">2</TD><TD style="FONT-WEIGHT: bold"></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="FONT-WEIGHT: bold"></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 21px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">3</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #c0c0c0; FONT-WEIGHT: bold">Date</TD><TD style="BACKGROUND-COLOR: #c0c0c0; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #c0c0c0; FONT-WEIGHT: bold">Home Loan </TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #c0c0c0; FONT-WEIGHT: bold">Car Loan </TD><TD style="BACKGROUND-COLOR: #c0c0c0; FONT-WEIGHT: bold"></TD><TD style="BACKGROUND-COLOR: #c0c0c0; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #c0c0c0; FONT-WEIGHT: bold">Total</TD><TD style="FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #c0c0c0; COLOR: #333399; FONT-SIZE: 13pt; FONT-WEIGHT: bold">Rent </TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #c0c0c0; COLOR: #333399; FONT-SIZE: 13pt; FONT-WEIGHT: bold">Amount </TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #c0c0c0; COLOR: #333399; FONT-SIZE: 13pt; FONT-WEIGHT: bold">Date </TD><TD></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">4</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-WEIGHT: bold">1/06/2012</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-WEIGHT: bold">$ - </TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff">$ 390.00 </TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff">1-May</TD><TD></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">5</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-WEIGHT: bold">2/06/2012</TD><TD></TD><TD style="TEXT-ALIGN: right">$ 500.00 </TD><TD></TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-WEIGHT: bold">$500.00 </TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff">$ 390.00 </TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff">8-May</TD><TD></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">6</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-WEIGHT: bold">3/06/2012</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-WEIGHT: bold">$ - </TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff">$ 390.00 </TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff">15-May</TD><TD></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">7</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-WEIGHT: bold">4/06/2012</TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: right">$ 100.00 </TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-WEIGHT: bold">$100.00 </TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff">$ 390.00 </TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff">22-May</TD><TD></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">8</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-WEIGHT: bold">5/06/2012</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-WEIGHT: bold">$ - </TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff">$ 390.00 </TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff">29-May</TD><TD></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">9</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-WEIGHT: bold">6/06/2012</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-WEIGHT: bold">$ - </TD><TD></TD><TD style="BACKGROUND-COLOR: #993366; COLOR: #ffffff">TOTAL</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #993366; COLOR: #ffffff">$ 1,950.00 </TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">10</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-WEIGHT: bold">7/06/2012</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-WEIGHT: bold">$ - </TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-WEIGHT: bold">8/06/2012</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-WEIGHT: bold">$ - </TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">12</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-WEIGHT: bold">9/06/2012</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-WEIGHT: bold">$ - </TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">13</TD><TD style="BACKGROUND-COLOR: #c0c0c0; FONT-WEIGHT: bold">ETC </TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="BACKGROUND-COLOR: #c0c0c0; FONT-WEIGHT: bold"></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">14</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-WEIGHT: bold">1/07/2012</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-WEIGHT: bold">$ - </TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">15</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-WEIGHT: bold">2/07/2012</TD><TD></TD><TD style="TEXT-ALIGN: right">$ 500.00 </TD><TD></TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-WEIGHT: bold">$500.00 </TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">16</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-WEIGHT: bold">3/07/2012</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-WEIGHT: bold">$ - </TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">17</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-WEIGHT: bold">4/07/2012</TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: right">$ 100.00 </TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-WEIGHT: bold">$100.00 </TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">18</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-WEIGHT: bold">5/07/2012</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-WEIGHT: bold">$ - </TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">19</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-WEIGHT: bold">6/07/2012</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-WEIGHT: bold">$ - </TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">20</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-WEIGHT: bold">7/07/2012</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-WEIGHT: bold">$ - </TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">21</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-WEIGHT: bold">8/07/2012</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-WEIGHT: bold">$ - </TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">22</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-WEIGHT: bold">9/07/2012</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-WEIGHT: bold">$ - </TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">23</TD><TD style="BACKGROUND-COLOR: #c0c0c0; FONT-WEIGHT: bold">ETC </TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="BACKGROUND-COLOR: #c0c0c0; FONT-WEIGHT: bold"></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">24</TD><TD style="BACKGROUND-COLOR: #c0c0c0; FONT-WEIGHT: bold">Totals</TD><TD style="BACKGROUND-COLOR: #c0c0c0; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-WEIGHT: bold">$ 1,000.00 </TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-WEIGHT: bold">$ 200.00 </TD><TD style="BACKGROUND-COLOR: #c0c0c0; FONT-WEIGHT: bold"></TD><TD style="BACKGROUND-COLOR: #c0c0c0; FONT-WEIGHT: bold"></TD><TD style="BACKGROUND-COLOR: #c0c0c0; FONT-WEIGHT: bold"></TD><TD style="FONT-WEIGHT: bold"></TD><TD style="FONT-WEIGHT: bold"></TD><TD style="FONT-WEIGHT: bold"></TD><TD style="FONT-WEIGHT: bold"></TD><TD style="FONT-WEIGHT: bold"></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">25</TD><TD style="FONT-WEIGHT: bold"></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="FONT-WEIGHT: bold"></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">26</TD><TD style="FONT-WEIGHT: bold"></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="FONT-WEIGHT: bold"></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR></TBODY></TABLE>

 

[Smitty]

Unfortunately, I'm outta' here for the day, so we'll need to rely on some of the other board folks to pitch in from here.

I'll try to check back in tomorrow though.

If you don't get an answer in a reasonable amount of time you can always reply to your post with "Bump" as the message, which will move it back up to the top of the forum.

 

[Wens]

bump

 

[Wens]

if anyone is able to help me out that would be fantastic, thanks

 

[Smitty]

I'd think you could use INDEX/MATCH to search for the date in each sheet, and if it's found then return the value.

Excel 2010
	A	B	C	D	E	F	G	H	I	J	K
3	Date		Home Loan	Car Loan	Rent		Total		Rent	Amount	Date
4	1/6/2012									$390.00	1-May
5	2/6/2012		$500.00				$500.00			$390.00	8-May
6	3/6/2012									$390.00	15-May
7	4/6/2012			$100.00			$100.00			$390.00	22-May
8	5/8/2012				$390.00		$390.00			$390.00	29-May
9	6/6/2012								TOTAL	$1,950.00
10	7/6/2012
11	8/6/2012
12	9/6/2012
13	ETC
14	1/7/2012
15	2/7/2012		$500.00				$500.00
16	3/7/2012
17	4/7/2012			$100.00			$100.00
18	5/7/2012
19	6/7/2012
20	7/7/2012
21	8/7/2012
22	9/7/2012
23	ETC
24	Totals		$1,000.00	$200.00	$390.00		$1,590.00
Sheet1

Cell Formulas
Range	Formula
E4	=IF(ISNUMBER(MATCH(A4,$K$4:$K$8,0)),INDEX($J$4:$J$8,MATCH(A4,$K$4:$K$8,0),0),"")
E5	=IF(ISNUMBER(MATCH(A5,$K$4:$K$8,0)),INDEX($J$4:$J$8,MATCH(A5,$K$4:$K$8,0),0),"")
E6	=IF(ISNUMBER(MATCH(A6,$K$4:$K$8,0)),INDEX($J$4:$J$8,MATCH(A6,$K$4:$K$8,0),0),"")
E7	=IF(ISNUMBER(MATCH(A7,$K$4:$K$8,0)),INDEX($J$4:$J$8,MATCH(A7,$K$4:$K$8,0),0),"")
E8	=IF(ISNUMBER(MATCH(A8,$K$4:$K$8,0)),INDEX($J$4:$J$8,MATCH(A8,$K$4:$K$8,0),0),"")
E9	=IF(ISNUMBER(MATCH(A9,$K$4:$K$8,0)),INDEX($J$4:$J$8,MATCH(A9,$K$4:$K$8,0),0),"")
E10	=IF(ISNUMBER(MATCH(A10,$K$4:$K$8,0)),INDEX($J$4:$J$8,MATCH(A10,$K$4:$K$8,0),0),"")
E11	=IF(ISNUMBER(MATCH(A11,$K$4:$K$8,0)),INDEX($J$4:$J$8,MATCH(A11,$K$4:$K$8,0),0),"")
E12	=IF(ISNUMBER(MATCH(A12,$K$4:$K$8,0)),INDEX($J$4:$J$8,MATCH(A12,$K$4:$K$8,0),0),"")
E24	=SUM(E4:E23)
G4	=SUM(B4:F4)
G5	=SUM(B5:F5)
G6	=SUM(B6:F6)
G7	=SUM(B7:F7)
G8	=SUM(B8:F8)
G9	=SUM(B9:F9)
G10	=SUM(B10:F10)
G11	=SUM(B11:F11)
G12	=SUM(B12:F12)
G13	=SUM(B13:F13)
G14	=SUM(B14:F14)
G15	=SUM(B15:F15)
G16	=SUM(B16:F16)
G17	=SUM(B17:F17)
G18	=SUM(B18:F18)
G19	=SUM(B19:F19)
G20	=SUM(B20:F20)
G21	=SUM(B21:F21)
G22	=SUM(B22:F22)
G23	=SUM(B23:F23)
G24	=SUM(G4:G23)
C24	=SUM(C4:C23)
D24	=SUM(D4:D23)
F24	=SUM(F4:F23)

Although Quicken is far better for this.

 

[Wens]

this is way over my head, and i think we are talking different things?? the first table was an example of the amounts that i want to appear in the worksheet when it and past the date (ie on the 2nd of each month i want the $500 to auto appear in the cell next its date and under the home loan) its a recurring payment so i dont manually have to put it in each month
the second table i want a similar thing but since its a weekly payment on a tueday the date will always be different so i want to the $390 to appear after the date that is next to it (K4-K8)
i have no doubt that there would be an easier program but this is the one that i have
but if your answer is what i want and i just dont understand im sorry
Thanks again for you time