Finding Budgets by day

[adovix]

In advance I would like to thank anyone who can help me here. I have not got a lot of experience in coding in excel but I am amazed at what it really can do. I have something I can not figure out even after searching the forums:

To simplify it I have a list of dates in column A then followed by the budget for that day in column B.

I want a script to fill in a completely new cell that goes down the list of dates and pulls the right budget and fills it in properly.

I am sure this must be simple to do, I just lack the knowledge of all the possible commands.
This is my example

Goal=

[TABLE="width: 140"]
<TBODY>[TR]
[TD="align: right"]9/8/2014</SPAN>[/TD]
[TD="align: right"]$597.81</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]9/9/2014[/TD]
[TD="align: right"]$614.27[/TD]
[/TR]
[TR]
[TD="align: right"]9/10/2014[/TD]
[TD="align: right"]$580.35[/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
</TBODY><COLGROUP><COL><COL></COLGROUP>[/TABLE]

 

[venkat1926]

your requirement not clear see the data here is this what you want, viz.the formula in G2

Sheet1

*	A	B	C	D	E	F	G
date	budsget	*	*	*	*	*
*	*	*
*	*	*	*	*
*	*	*	*	*

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:78.4px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:68.8px;"><col style="width:64px;"></colgroup><tbody>
[TD="bgcolor: #cacaca, align: center"]1[/TD]

[TD="bgcolor: #cacaca, align: center"]2[/TD]
[TD="align: right"]9/8/2014[/TD]
[TD="align: right"]$597.81 [/TD]

[TD="align: right"]9/10/2014[/TD]
[TD="align: right"]580.35[/TD]

[TD="bgcolor: #cacaca, align: center"]3[/TD]
[TD="align: right"]9/9/2014[/TD]
[TD="align: right"]$614.27 [/TD]

[TD="bgcolor: #cacaca, align: center"]4[/TD]
[TD="align: right"]9/10/2014[/TD]
[TD="align: right"]$580.35 [/TD]

</tbody>

Spreadsheet Formulas

Cell Formula G2 =VLOOKUP(F2,A2:B4,2,0) <tbody> </tbody>

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

 

[adovix]

Perfect, that is exactly what I want. I need to modify it a bit for my needs but the vlookup is the command I could not figure out. Thank you so much!

 

[Adi21]

Try this:

For i = 2 To Sheets("1").UsedRange.Rows.Count
If DateValue(ThisWorkbook.Sheets("1").Cells(i, 1)) = DateValue(ThisWorkbook.Sheets("1").Cells(2, 6)) Then
Range("G2").Value=Range("B" & i).Value
End if
Next