Hello All,
Just thought I would ask for an alternative and slightly more manual option, that can be used on a case by case basis.
If I was to manually select the blank cell below each of my contiguous calculations, is there a Worksheet_BeforeDoubleClick macro that would subtract the range of cells above the double click formula from the value in the top cell i.e top cell minus SUM below?
The problem with some of the earlier solutions was that my cells contained formulas and the .SpecialCells(xlConstants, xlNumbers) looks for numbers, not formulas.
I use the range of calculations to work out the axle spacing’s of different trucks.
For example....
Axle 1 to 2 = 3,885 - (1,370/2) = 3,200 mm
Axle 2 to 3 = 1,370
Axle 3 to 4 = 8,200 - 50 - (1,370/2) - 1,220 = 6,245
OR 8,200 - SUM(D3
5) = 6,245
Axle 4 to 5 = 1,220
Axle 5 to 6 = 1,220
Axle 6 to 7 = 5,810 - 1,220 - (1,380/2) = 3,900
OR 5,810 - SUM(G3:G4) = 3,900
Without attaching another workbook, I hope the above example makes sense.
Regards, Dave T