I have a query which I cannot fathom out the way to do it.
I am creating a bit of vba that goes through some database tables to compare to those in a different version of the same database for testing purposes.
The script I have works fine at comparing the data however some of the tables are in different orders. What I need to do is sort the data according to a unique identifier, here in lies my issue.
The column of the identifier isnt always in the same place ie I would want it always in column A but as its third party software I have no control over this.
What I would like to know is is there a way to get a vba code look through the columns of a given table and find the column which contains only unique values?
Thanks in advance