I want to copy a cell by date if Cell = Today() then...

[quickquestion]

Here is my situation. I have a workbook that needs to have th
following:

1 2 3 4 - 31 Days of the Month

In the cell underneath the days I need it to put the total earned fo
that day. So I need to do an analysis by day for the totals. I wan
to automate this whole process.

Here is what I have so far, but ofcourse it isn't working:

=IF(B38=Q13,F3,"")
B38 is a =DAY(B35)
B35 is a simple =Today()

In my If stament I'm overwriting the old cell value. Yesterday all th
15's were filled out. Now today they are blank while all the 16s ar
filled out. I need to setup and graph this whole process so I need i
to keep yesterdays value in yesterdays cell. Just leave it alone til
next month when date = num.

Thank you for any help

 

[Ardus Petus]

Try this:
=IF(B38>=Q13,F3,"")

That will leave your previous days filled

HTH

 

[quickquestion]

Why did mine delete it though? Because I didn't have the > than sign?

 

[Ardus Petus]

Precisely!

Cheers,