VB Macro to write formula in a cell

Hello:

Please refer to attached file.
I have following sheets
Daily_Receipt, Report and Daily_Deposit

Sheet "Daily_Receeipt" will have clock In - Clock Out info for employees in cell O65:EG101.
I need a VB macro to write the formula in a cell based on date shown in column G and pick up data from Daily_Receipt
from corresponding date in row 65.

For example i need VB Macro for 7/1/2014 (Match the date in Daily_Receipt) so that in Report sheet

F50 = Daily_Receipt!O66
G50 = =Daily_Receipt!P66
H50 = =Daily_Receipt!Q66
I50 = =Daily_Receipt!R66

F51 = Daily_Receipt!O67
G51 = =Daily_Receipt!P67
H51 = =Daily_Receipt!Q67
I51 = =Daily_Receipt!R67

like above until as below for 7/1/2014

F85 = Daily_Receipt!O101
G85 = =Daily_Receipt!P101
H85 = =Daily_Receipt!Q101
I85 = =Daily_Receipt!R101


For 7/2/2014 (add 44 rows, 50+44 willmake F50 + 44 rows start row for 2nd of the month will be F94)

F94 = Daily_Receipt!S66
G94 = =Daily_Receipt!T66
H94 = =Daily_Receipt!U66
I94 = =Daily_Receipt!V66

F51 = Daily_Receipt!S67
G51 = =Daily_Receipt!T67
H51 = =Daily_Receipt!U67
I51 = =Daily_Receipt!V67 and so on..

Let me know if you have any questions.
Thanks.

Riz

Hello:

Updated file is attached..

Let me know if you have any questions.
Thanks.

Riz

Hello:

Has anyone had a chance to look into this.
Let me know if you have any questions.
Thanks.


Riz