Good Morning Folks;
I have a sheet with 15 columns that I will be using to populate a SQL database. I order to make sure that the DB has been populated correctly I would like to copy the contents of the db into another spreadsheet and then compare the the original spreadsheet to the one that I copied from the db.
To make a long story short is there a way I can compare two sheets and find out the differences in them without having to go and compare one column at a time??????????
I have a sheet with 15 columns that I will be using to populate a SQL database. I order to make sure that the DB has been populated correctly I would like to copy the contents of the db into another spreadsheet and then compare the the original spreadsheet to the one that I copied from the db.
To make a long story short is there a way I can compare two sheets and find out the differences in them without having to go and compare one column at a time??????????