Ed, Thanks for your note.
I am not using the ScoutNet report macro. I keep the list of Counselor Badges in an Access DataBase, not on ScoutNet. I found it too difficult to manage 1500 counselors and over 8000 badges on ScoutNet.
Counselor registration information is downloaded from ScoutNet and populated into my data base. ScoutNet is my authorative source for all data, except the list of badges, and any unit associations. So that is why I am asking about the sort order. If the Excel macro sorts by the BSA Member ID, I will modify my upload table to be sorted by that as well. Currently it is sorted by LastName, FirstName. It works OK they way it is now, but if sorting it by MemberID will save some extra work on the ScoutBook end, I am glad to do that.
And BTW. I just uploaded our council list with a couple of new counselors, and discovered that not only were they added, but all of the missing Merit Badges were added too!!!
That is great! For the very first time the contents of the upload and download files match!
Thanks to the support team for taking care of this. It will make a lot of my local troops happy to see the missing badges show up on their ScoutBook record.