Importing and Auditing data from SharePoint to an Excel Spreadsheet
===

So I bring in data from a Sharepoint Calendar and into an excel spreadsheet.  Is there a way that whenever I import new data from sharepoint it loops through the uniqiue ID that Sharepoint provides and check to see if it has been deleted from the data thats incoming?

So checking against new data coming in against the data currently in the system?

I think what I'll have to do, is upon importing data, store the data in a "Temporary" spreadsheet, then run the loop to comapre the ID's of the Temporary sheet to the Data sheet, then handle the Audit process, then update Temporary to the Data sheet, and lastly delete the temporary sheet.

Anybody know of what commands/macros would be useful for this??