Ok, so at work right now, I'm exporting around 30,000 user's mailboxes due to a legal hold. The Security department is providing me a list of users in an Excel sheet. (Really there were 100,000 users but I've already used a vlookup to figure out which users we didn't have archives for.) But, yesterday they sent a new revised list removing about 10,000 users from the original list and adding about 18 users. But tomorrow they could send me a list asking me to add 5,000 users and remove 200. So, I'm trying to figure out a way to keep track of this. I'm attaching a sample spreadsheet. I have a main tab that has email addresses. Down to the line where I wrote "Added from 2-14 Update", those users were the original users provided by security. Then they sent me an updated list that listed everyone they wanted exported. Now I can't just use the new list to export the users. The first list they provided me had the user's display name, their account name, and email address. I can't export based on email address. That's just the way it works. The updated list only had the user's email addresses. Nothing else. I had to then fiilter the original main tab from the list they provided me using a vlookup to tell if a user on the new list wasn't on the old list. That worked, except there were the 18 users they added. 18 isn't a big deal to add, but if they would've sent me 1,000 users added to their updated spreadsheet, I need the function to see that it's not on the main spreadsheet and add a line to the main spreadsheet with the user it found on the updated spreadsheet to the main spreadsheet. But Security could send me another list tomorrow that will be revised again. I need for the function to somehow say well, the email address was on the main tab, it wasn't on the 2-1 tab, but it is on the 2-14 tab. So, because 2-14 is the later date, add it to the main sheet. But if it's not on either of the 2-1 or 2-14 tab, remove it. Then if they add a brand new email address on 2-14, add it to the main tab.
I dont know if this is possible.
Attached is an example spreadsheet simliar to what i'm using at work. (the one at work has a lot more info than just the email address.) The main sheet, if it sees an email is removed, needs to remove the whole line for the user with the display name and everything else.
Bookmarks