In a business sometime some liabilities are created like creditors, tax payments etc. and also assets like sundry debtors, to collect the payments. And it is important to follow these things to clear your liabilities and assets. But sometime we forget and not follow on time, this effects our business and money. So you must do everything on time with a clear schedule to prevent loss in business.
But now you can make it better with this VBA enabled outstanding tracker excel sheet. In this you can maintain your debtors or creditors outstanding with all details, and also you can highlight your followed customer with one click.
It is also very useful for call centers or who follow customers.
It possible through simple VBA codings. By these codings you can make your own templates according to your work.
These are some simple coding for this macro enabled workbook:
In Excel Sheet1 –
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not Intersect(Target, Range(“b4:b17”)) Is Nothing Then If Target.Count > 1 Then Exit Sub If Target.Value = “þ” Then Target.Value = “o” Else: Target.Value = “þ” End If End Sub
In Module – Sub CheckAll() With Sheet1 If .CheckBoxes(“Check Box 1”).Value = 1 Then .Range(“b4:b17”).Value = “þ” Else: .Range(“b4:b17”).Value = “o” End If End With End Sub
But before paste these codes in your workbook you must do some important things like adding some formula with conditional formatting tab of excel. For complete tutorial you must see above video.
If you want to download this Outstanding Tracker go through below download button: –
If you find it useful for you or want some more modification in the sheet please comment below.