Hello,
I have a sheet called Daily Workload where cell B6 has the value =now()
Cell c26 has a numeric value in it that changes with a formula.
I have a CommandButton1 which when pressed resets the value of C26 to 0
Before the Value of C26 is changed back to 0, I want it to update another worksheet called Monthly Workload whith the amount, but placing it in the relevent monthly cell (eg if the date is 13/01/04 then I want the value of C26 to be added to the January cell).
Has any of you very kind people out there got any ideas?
PS Slowly but surely I am picking this up!!!!! It is a very steep learning curve though (I only started to use MS Excel since the 1st day I came on here and didn't even know what a spreadsheet was before then!)
I have a sheet called Daily Workload where cell B6 has the value =now()
Cell c26 has a numeric value in it that changes with a formula.
I have a CommandButton1 which when pressed resets the value of C26 to 0
Before the Value of C26 is changed back to 0, I want it to update another worksheet called Monthly Workload whith the amount, but placing it in the relevent monthly cell (eg if the date is 13/01/04 then I want the value of C26 to be added to the January cell).
Has any of you very kind people out there got any ideas?
PS Slowly but surely I am picking this up!!!!! It is a very steep learning curve though (I only started to use MS Excel since the 1st day I came on here and didn't even know what a spreadsheet was before then!)