So I am looking for a way of sorting entered data ascending to then use in a sub-dv list. Basically, on the attachment below, a user enters in details on the application sheet. Here there are two columns of interest, CRN and application number. Each application number is unique, but each CRN can have multiple application numbers. On the List sheet, I was hoping to have the CRN column sorted ascending including multiple matches and then display their corresponding application number.
I had a go at it, but I'm failing to get exactly what I was hoping for. I believe there is a way of doing it using functions and not VBA, so I was hoping to find this solution (but for me, it was to no avail!)
Any help would be greatly appreciated!
SortingExample.xlsx
Bookmarks