I captured the VB code code for copying the unique values for the list in A3:A39, and putting the result in A41
Range("A3:A39").AdvancedFilter Action:=xlFilterCopy, CopyToRange:=Range( _ "A41"), Unique:=True
I want to repeat this process for Columns B - BL but I can't figure out how to loop through it for the different columns.
Bookmarks