I have 2 columns of data, the 1st has names and the second has numbers. I'd like to sort the data alphabetically then get rid of the duplicate name in the name column and move the numbers over a column.
I tried recording a macro using the sort in excel and when I put in the range I had set it gave an error (subscript out of range on the 2nd line that starts with "ActiveWorkbook").
I checked the variable "SortRng" and it does refer to the 2 columns and rows I want. Here is the relevant code and an example of the kind of data I'm working with.
Please Login or Register to view this content.
Bookmarks