Excel help

hans gruber · 9 Jun 2023 at 15:12

I want to calculate the total for a column of values. I then want to be able to remove values from the column but the total previously calculated not be affected.

Is there a way to do this? I know I could just convert the result to text but would rather skip having to do this.

SilverTongue · 9 Jun 2023 at 15:26

sorry ignore me

BluesFanUK · 12 Jun 2023 at 18:49

Sound like something you'd need to do in VBA. Look at this.

hans gruber · 20 Jun 2023 at 19:25

Ended up going with this in the end:

Code:

For y = 1 To LastColumn
If Worksheets("Sheet1").Cells(3, y) Like "RP" Then
If Worksheets("Sheet1").Cells(35, y) < Application.Sum(Range(Cells(4, y), Cells(30, y))) Or Worksheets("Sheet1").Cells(35, y) Like "" Then
Worksheets("Sheet1").Cells(35, y) = Application.Sum(Range(Cells(4, y), Cells(30, y)))
End If
End If
If Worksheets("Sheet1").Cells(3, y) Like "Donations" Then
If Worksheets("Sheet1").Cells(35, y) < Application.Sum(Range(Cells(4, y), Cells(30, y))) Or Worksheets("Sheet1").Cells(35, y) Like "" Then
Worksheets("Sheet1").Cells(35, y) = Application.Sum(Range(Cells(4, y), Cells(30, y)))
End If
End If
Next y