GribbiN
12-22-2015, 04:58 AM
Good Morning,
Due to my lack of VBA knowledge i currently have a complicated way of adding the value of one column to a running total in another.
I currently have hidden columns which add the total and input value together, then the hidden columns are copied and pasted to replace the total then the input value cleared for the next cycle.
Although my method and recorded macro works fine there are other items we log throughout the year so would like to simplify the code and sheets. As there is a lot more manual work my way
With a working macro i would delete all hidden columns so the code would be for this
D Input/E Total
F Input/G Total
H Input/I Total
J Inout/K Total
Not all input cells will have values each day
As with all the help i have received in the past thanks in advance and Happy Holidays
John
15018
Due to my lack of VBA knowledge i currently have a complicated way of adding the value of one column to a running total in another.
I currently have hidden columns which add the total and input value together, then the hidden columns are copied and pasted to replace the total then the input value cleared for the next cycle.
Although my method and recorded macro works fine there are other items we log throughout the year so would like to simplify the code and sheets. As there is a lot more manual work my way
With a working macro i would delete all hidden columns so the code would be for this
D Input/E Total
F Input/G Total
H Input/I Total
J Inout/K Total
Not all input cells will have values each day
As with all the help i have received in the past thanks in advance and Happy Holidays
John
15018