formula for running YTD total data taken from column updated daily... I am OVERTHINKING it

hello all,

I have been trying different formulas and I am stuck. I am new to excel formulas and trying to make our work easier..LOL.


Here is my problem:

I have columns that are updated with numbers daily and I want to have them keep a running YTD total in the columns that coincide with it.
I have attached the worksheet. I though maybe entering the daily data on a different sheet, but I really don't think that would help.

Columns F thru I will be updated daily and if there is no data ...reset to zero. I want to take that data and have it keep a running total in the YTD columns. But when the columns get reset it changes the total.

I am stuck and really need some help. Am I really off base with what I am trying to or is there and easier way?
I appreciate ANY help you can give me...thank you!

with this code in Worksheet_Change

Please Login or Register  to view this content.

Kind regards
Leo

something is wrong it wont let me download and open the file

you can copy the code and paste in your own file


open VBA with Alt Function 11
choose Insert Module
and paste


Kind regards
Leo

OK I saved with dif name and got it open, but there is no worksheet labeled worksheet _change, but I do see the VBA code under the developer tab. thanks for your help with this

very good suggestion and that is what I have done with the daily and you are right I think it will work better. the test is old so I need to delete it Thanks so much I will try and post my results. need to figure out the formula to have it copy from my 2 daily worksheets to the master by current date... here we go again! lol

OK I have re-done my workbook to have daily data entry. now I am struggling with how do I get the formula built to have it look in the fires and RX sheets by the current date and copy that data to the master sheet for the daily total (next to the year to date. I don't know if I should use Vlookup or a match function ...do you have suggestion for that? I have attached the revised spreadsheet. I want it to reference the current date which I have the =today() formula on both sheets and find the corresponding info for the boxes on the master sheet by the headers and copy it to those individual boxes.

OK I have re-done my workbook to have daily data entry. now I am struggling with how do I get the formula built to have it look in the fires and RX sheets by the current date and copy that data to the master sheet for the daily total (next to the year to date. I don't know if I should use Vlookup or a match function ...do you have suggestion for that? I have attached the revised spreadsheet. I want it to reference the current date which I have used to formula =today() on both sheets look it up on the fires and RX sheets by the current date and copy the information into the matching boxes on the master sheet. I am struggling with how to build the formula

we have to add the data daily and then the master is the form we email to another dispatch center. we were having to hand crank the totals and I was TRYING to make it easier and learn more about formulas...but not sure I am . SO I am trying to set this up for this coming year. Maybe I am making it to complicated and there is an easier way.. ie calculator. LOL

Ok I figured it out and changed the formulas so now it works for both. THANK YOU FDibbins!!!!!!!