So I have this spreadsheet that has about 500 stores listed each in their own row with various information. I am currently making changes and adding to this list. My issue is that I am currently getting an updated list every few weeks with some stores being added and drooped from the previous. I would like to know if there was an easy way to compare the two lists and find out what changes have been made between the two (which stores have been added/dropped from the previous list). The reason I would like to do this is becuase I have been adding to the original list and would like to keep all of my updates to that list and just continue to build off of this.

If anyone has any good ideas on how I should manage these lists, please let me know!

As always thanks again in advanced for all the input and help.

-Greg