Hi all,

I'm having trouble figuring out how I can subtract a value in column B of a spreadsheet from a total in column C which has been added in using a "copy/paste to next blank row".

The value in col B will have been added manually, but it's value must be subtracted from the value in the same row of col C. I need to run the macro repeatedly so each time the macro is run the new row of data that is copied into col C should have the value in Col B subtracted from it.

Ideally I would like to add this stage in immediately following the copy and paste macro included below; many thanks for any help.

Sub CopyLOData()
Dim lrb As Long
With Sheets("LondonOverview")
lrb = .Range("C" & Rows.Count) .End(3).Row
Sheets("ATSPivot").Range(C18:F18".Copy .Range("C" & lrb + 1)
End With

End Sub