Break List into Groups [Example]

[JMichaelTX]

@JMichaelTX

MACRO: Break List into Groups [Example]

I have just posted a version of this macro which is specifically focused to @BillytheHicks requirements here:

Find and cut lines from list to new list based on name

OK, so using an abbreviated set (4 groups, limited rows) of data from your last Source Data, I have a revised Macro that will produce this: Example Output [image] I have changed most KM Variables from Local to Global variables (meaning that they were persist permanently until deleted). All of these Global Variables have a prefix of: DND_ETC__ which means "Do Not Delete" and then "Extract Time Codes". Hopefully this will allow you to create/keep these variables without accidental interac…

Primary Changes:

1. No longer sort the source data -- it MUST already be ordered with all lines of a group together.
2. Changed most Local variables to Global variables to permit use in other macros.
3. For Even-Numbered Groups, extract the Group Name, TimeCode In, TimeCode Out