Script which can check if a debit has a corresponding credit
Solved/Closed
dennisvhansen
Posts
7
Registration date
Wednesday September 9, 2015
Status
Member
Last seen
September 24, 2015
-
Sep 9, 2015 at 07:44 AM
dennisvhansen Posts 7 Registration date Wednesday September 9, 2015 Status Member Last seen September 24, 2015 - Sep 24, 2015 at 02:30 AM
dennisvhansen Posts 7 Registration date Wednesday September 9, 2015 Status Member Last seen September 24, 2015 - Sep 24, 2015 at 02:30 AM
Related:
- Macro for matching debits and credits in excel
- Excel date format dd.mm.yyyy - Guide
- Spell number in excel without macro - Guide
- Screenshot in excel - Guide
- 1st, 2nd, 3rd position formula in excel ✓ - Office Software Forum
- Macros in excel download - Download - Spreadsheets
3 replies
Using the file you posted.
I skipped the zero values, as these would all match each other.
You can change the ranges to suite.
I skipped the zero values, as these would all match each other.
You can change the ranges to suite.
Sub finddupes()
dim found as Boolean
For Each mycell In Worksheets("Ark1").Range("B2:L34")
myvalue = Abs(mycell.Value)
If myvalue <> 0 Then
found = False
For Each chkcell In Worksheets("Ark1").Range("B2:L34")
If mycell <> chkcell Then
If myvalue = Abs(chkcell.Value) Then
chkcell.Interior.ColorIndex = 4 ' Green
mycell.Interior.ColorIndex = 4
found = True
End If
End If
Next
If found = False Then mycell.Interior.ColorIndex = 3 'Red
End If
Next
End Sub
Sep 17, 2015 at 03:14 AM
Sep 17, 2015 at 03:16 AM