Hi all,
I've been thinking of how to write code for this particular project, but to no avail. This is what I hope to achieve:
To populate Denver to Dublin in C2, Amsterdam to Dublin in C3, Amsterdam to Dublin in C4, all the way down column C.
The reason I am having trouble with this is that it the string in column C has to be according to alphabetical order, not according to Origin to Destination (e.g. even though Amsterdam is my destination, and Dublin is my origin, it should populate Dublin to Amsterdam in C3:C5)
I need to repeat this all the way down column C for all corresponding fields in column A and D.
Any help on this matter would be greatly appreciated! Thank you.countrysamp.xlsxcountrysamp.xlsx