Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Non-consecutive numbers in Macro
After not wanting to, it looks like I do need to create a
macro. How would I do the following to make sure that it captures a range of missing numbers (1006-1008 below)? I need to find all gaps in the Invoice # list and flag the numbers to a new worksheet(#2), preferably all listed in Column A without gaps. Worksheet #1 Worksheet #2 Invoice# Customer Invoice# 1001 Acme 1003 1002 Davis 1006 1004 Shopstar 1007 1005 Walker 1008 1009 Trains Thanks for any help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Highest 3 in 10 Consecutive Numbers | Excel Worksheet Functions | |||
Consecutive Numbers | Excel Discussion (Misc queries) | |||
consecutive numbers | Excel Worksheet Functions | |||
Consecutive numbers in 1 cell | Excel Worksheet Functions | |||
consecutive numbers | Excel Worksheet Functions |