Macro to apply filter, use if statement to generate subtotal, return value

[VBA_Newguy]

Hello,

My workbook has two sheets: Input (large bank of data) and Output (simplified presentation sheet)

I need a macro that will perform in the following order:

(1)sort the Input sheet by column A
(2)On the Input sheet run an if statement on column K and L where --> If (absolute(Column K)) - (Absolute(Column L)) > 100, then the value of ($K - $L) is added to a running subtotal
(3)return value of the summed subtotal to Output sheet


My main problem comes with form the If statement to run a subtotal.

Many thanks in advance Excel Forum.