Find missing values in sequences, repeat for many ranges in a single sheet

**KRMd** · 10-28-2012, 06:39 PM

Hi all-

Frequent visitor, macro-beginner, and first-time poster:)

I have spreadsheets (example attached) with groups of data (indicated by "Image 1", "Image 2", etc. in column A) - each group is separated by a blank row. Each group needs to be represented by 61 rows of data, indicated by a continuous numeric sequence (from 1-61) in column B ("Time (min.)"). However, there are missing numbers in this sequence for most groups (e.g., the group "Image 1" is missing 1, 2, 4-12, 15-17 in column B, and so on). I would like a macro that can find these missing values in the sequences, insert a new row with the missing number entered into column B, and enter a value of "0" into column C (the remaining columns can be blank).

I found a code (below) that can perform this on a sheet with only one group, however, I have not been able to modify this code to perform the task on each group moving down the spreadsheet (i.e, for many ranges that are not uniform). Note, the spreadsheet attached contains a simple example with 3 groups - I have many spreadsheets with approximately 50 groups each to process.

Any help to create this macro would be appreciated!

Thanks much!

Please Login or Register  to view this content.

**rylo** · 10-28-2012, 07:00 PM

Hi

how about

Note that this code only does the sort on column A:C. While you indicate that there may be other columns, you don't advise how many columns are really involved, or how the last column to be included in the sort may be determined, so this aspect will have to be expanded.

Please Login or Register  to view this content.

rylo

**watersev** · 10-28-2012, 07:27 PM

option, press Run button

**KRMd** · 10-28-2012, 08:34 PM

Thanks for your quick replies, rylo and watersev! Both work perfect for what I need - this will be a big timesaver.

Thanks again!

**FDibbins** · 10-28-2012, 08:36 PM

If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neet and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below)