Accountant delete of less than or more then value in debtors

If you want to work in debtors / creditors ageing report & your boss said to you I want report of Assignment is pending or you want separate report of Ageing (Outstanding & Advances from Customers)

What are you doing in this type of situation?

My Simple way

·         Open your ageing report in excel

·         Copy your data & make 2 duplicate sheets

·         One Sheet is Debit Balances & 2^nd is Credit Balances

·         Then Go to 1^st Sheet – Debit Balances

·         Just Press Alt + F-11 Go to Insert – Module

·         & Just Paste Following Micros Program

Sub DelNegs()

Dim Rng As Range

For Each Rng In Selection

    If Rng.Value < 0 Then

        Rng.ClearContents

    End If

Next

End Sub

·         & Just Save this file Close the Module

·         Select your figures / values which you want to remove < 0

·         Go to Developer & Clik on Macros & Just clik on Run button

·         Your problem is solving within Second.