About Us

Jim[_22_]

Thanks for the quick response!!

"JMB" wrote in message
...
One example. Select the list of check numbers that are cleared and this
will
prompt for the lowest and highest check number and put the results in
Column
D (change the destination range as necessary).

Sub Test()
Dim lngFirst As Long
Dim lngLast As Long
Dim i As Long
Dim lngCount As Long
Dim rngData As Range

Set rngData = Selection
lngFirst = CLng(InputBox("First Check Number"))
lngLast = CLng(InputBox("Last Check Number"))
lngCount = 0

For i = lngFirst To lngLast
If Not IsNumeric(Application.Match(i, _
rngData, 0)) Then
lngcount = lngcount + 1
Range("D" & lngcount).Value = i
End If
Next i

End Sub

"Jim" wrote:

Is there an easy macro to get a list of missing(outstanding) check
numbers.
I can get a list of recent cleared check numbers and their amounts. It
would
be nice to get a list of missing checks in a column so I could just enter
the missing checks amounts and have a sum of the total amount still
outstanding.

For example the banks list might have:
11188 with the amounts too
11186
11185
11183
11182
11181
11180

Is there a macro that would tell give me a list of 11187 & 11184 in a
column
so I could list the corresponding amounts ans sum them? Thanks

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Finding Missing and duplicated Numbers	Ujpest	Excel Worksheet Functions	4	March 2nd 10 08:10 PM
Finding missing numbers in a sorted sequence	Liz	Excel Discussion (Misc queries)	3	March 9th 09 12:46 PM
Finding Missing Data	Jordan	Excel Worksheet Functions	1	August 10th 06 05:43 AM
Check for missing invoice numbers	luxboy	Excel Programming	3	June 30th 05 01:20 PM
Finding numbers missing from a sequence	andy	Excel Discussion (Misc queries)	3	April 8th 05 04:16 PM

Menu

About Us