Thank you for being here to learn from you ;-)

Issue: I have an excel 2016 spreadsheet that I am tasked to modify each day. The input is a copy/paste from a third app report. The report is basically a text file format.

Task: verify any changes from day to day and publish the result by posting the workbook.

Data: a derived text file which is copied from another app, in situ, and then pasted into a worksheet column in the workbook (for comparison to the previous day)

Data Structure: multiple groups with the membership of the group listed under the group name (note: groups have "members:" in the name. Members do not)
A) the structure of the Group Name is the same with this format: "group1 members:", "group2 members:", etc.
sorted by Group Name by default in the report

B) the structure of the Members Names uses this format: "name" OR "firstname lastname"
sort by first name (no quotes. I included those for readability ;-)

C) the Member section is unsorted. The representative data below shows how I need the result-set to look like

i.e.
group01 members:
User06 lastname
user01 lastname
user02 lastname
user10 lastname

...

group02 members:
User02 lastname
user01 lastname
user06 lastname
user10 lastname
...

group03 members:
User10 lastname
user01 lastname
user02 lastname
user06 lastname
...

group04 members:
User01 lastname
user02 lastname
user06 lastname
user10 lastname
...

group05 members:
User02 lastname
User10 lastname
user01 lastname
user06 lastname
...

...


in addition to this, part of the sort for the Members would be Capital Letters first, then non-capital letters:

User99 would be before any user01

Sorry if the data presented is sparse, but I think it represents what I am trying to do. The actual data is classified.

I am currently going into each group and manually sorting the Members. The Groups are sorted properly by default from the report structure. I am unable to have the report modified to get the 2nd level sort of the Members or do the Members sort with uppercase names first, then lowercase names.

Rules: without disturbing the sorting for "Groupxx members:" that comes from the copied report section. This is in one column only - have to do it in that column or create new column to work in that will end up being the fully sorted result-set.

1) Sort Members under the Group alphabetically ascending
2) Sort Members by Uppercase first character - alphabetically ascending, then lowercase first character - ascending

I vaguely remember using a "bubble sort" in C, but I do not know how to do this either with a macro or VB in excel ¯\_(ツ)_/¯

Thank you for your help with this. The solution could save me 5 - 10 hours a week ;-)

P.S. there are several additional steps needed to get this workbook ready for publication, but I have no other issues once this is accomplished. I already have that macrated and it works well.

rozark - newbie ;-)