Hi,

This is a fairly simple question that I was trying to do
without creating a macro, but I think I will have to do
it. I have a list of items in numerical order, I need to
find any gaps in the Invoice # list and flag the number to
a new worksheet.

Invoice# Customer
1001 Acme
1002 Davis
1004 Shopstar
1005 Walker
1008 Trains

I would need the list to show that I'm missing Invoice #s
1003, 1006, and 1007. Thanks for any help.