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

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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