Subtract contiguous values from top cell, continuously in column, till end

Dave T · #1 11-25-2020, 08:31 PM

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Novice needs: Complicated running totals adding substracting non contiguous cells contiguous columns	innkeeper9	Excel	5	08-30-2016 04:43 PM
Subtract value from one cell into another	otuatail	Excel	3	02-01-2016 03:21 AM
Mouseover cell to indicate mouse pointer location based on Specific Row/Column values	bolandk	Excel	1	05-15-2014 08:22 AM
Summing Non Contiguous Cells in a Row or Column	Joe Ottenhof	Excel	4	12-19-2012 04:13 AM
From a particular cell till the end of the same column	tinfanide	Excel	3	08-10-2011 05:09 AM