Hi,
I have a work sheet in which I want to run VBA code for an accumulator to keep a running total. Unfortunately, VBA code is totally foreign to me.
I have found quite a few sites with VBA code that might work, eg http://www.mcgimpsey.com/excel/accumulator.html
I tried to copy it into the worksheet bit that didn’t work.
So, to the specifics – sheet ‘MSC’!P7:P156 - each cell has a value entered based on a DATEDIF calculation, i.e. it is not user entered. ‘MSC’!Q7:Q156 is where I want to keep the running total for each row.
Is the ‘Two Cell Accumulator’ code in McGimpseys website suitable to use? If so, how do I paste it into ‘MSC’ work sheet?
Any assistance in this would be greatly appreciated.
Thank you.
Pete
I have a work sheet in which I want to run VBA code for an accumulator to keep a running total. Unfortunately, VBA code is totally foreign to me.
I have found quite a few sites with VBA code that might work, eg http://www.mcgimpsey.com/excel/accumulator.html
I tried to copy it into the worksheet bit that didn’t work.
So, to the specifics – sheet ‘MSC’!P7:P156 - each cell has a value entered based on a DATEDIF calculation, i.e. it is not user entered. ‘MSC’!Q7:Q156 is where I want to keep the running total for each row.
Is the ‘Two Cell Accumulator’ code in McGimpseys website suitable to use? If so, how do I paste it into ‘MSC’ work sheet?
Any assistance in this would be greatly appreciated.
Thank you.
Pete