Subtract contiguous values from top cell, continuously in column, till end
Hello All,
I would like to insert a formula below each range of contiguous values in a specific range (B2:X21).
I would like to be able to subtract all of the contiguous values in each column from the top cell of that contiguous range.
I found a macro that is an example of what I am trying to achieve but this inserts a SUM formula below every contiguous range in columns B to E.
Columns F to I are manual examples of what I would like the macro to do when run.
I would prefer the macro to run from a button as I am already using a Worksheet_Change and do not need it to run every time.
Obviously where there is a single value as in cell C2 the macro does not need to inset a formula.
Any help appreciated.
Regards, Dave T
|