I was trying to figure this out. I have used excel quite a bit over the years but this approach seems to be beyond my understanding.

Basically, I am required by state law when running a campaign to keep track of contributor info and a daily summary of total contributions. I wanted to set up a formula that would grab the total based on date entered automatically and to summarize it with any other contributions on the daily summary sheet. Check out the attached worksheet!

I don't even know where to start or if I need to go to a higher level of programming than formulas to do it, i.e. VBA's or macros. Thank you in advance for your help.

Treasurer Worksheet.xlsx