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=

9/8/2014</SPAN>	$597.81</SPAN>
9/9/2014	$614.27
9/10/2014	$580.35

<TBODY>
</TBODY><COLGROUP><COL><COL></COLGROUP>

 

[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
1	date	budsget	*	*	*	*	*
2	9/8/2014	$597.81	*	*	*	9/10/2014	580.35
3	9/9/2014	$614.27	*	*	*	*	*
4	9/10/2014	$580.35	*	*	*	*	*

<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>
</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