Compare two sheets

[Curious]

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??????????

 

[marstonk]

A quick way would just to put if statements in a blank worksheet it if(sheet1!a1=Sheet2!a1,0,Error) And just copy the formula across the whole sheet. It will not take long. Therefore if something is different you get error. This could only work if your sheets are the same format with the data on.

Hope this helps.

kittyg

 

[Curious]

Thanks

I will try it