Hi,
First post, but I've read the forum rules before posting!
Background: I have a VB script (not written by me), which pulls out information from my client's Active Directory and dumps it into a Text file. I open the Text file in Excel, and use delimiters to separate everything into separate columns before Formatting As Table to allow easier filtering and sorting. I use this information to update the user list for my client's Learning Management System. I run this script once a week to add new users.
The Problem: As well as adding new users, I need to deactivate users who have left. Whenever someone leaves, my client adds them to an OU called LEAVERS, which is a column in my spreadsheet. However, I have no way of sorting the spreadsheet by the date a user was added to the LEAVERS OU.
The Question: Is there a way I can compare a spreadsheet from one week with a spreadsheet from another week to identify new rows that have been added? I'm thinking that if I filtered so only users that are in the LEAVERS OU show, then if I could identify new rows, that would be great.
I can't see how that would be possible, but I thought I'd ask in case there's another solution that anyone can think of. Thanks for your time!
First post, but I've read the forum rules before posting!
Background: I have a VB script (not written by me), which pulls out information from my client's Active Directory and dumps it into a Text file. I open the Text file in Excel, and use delimiters to separate everything into separate columns before Formatting As Table to allow easier filtering and sorting. I use this information to update the user list for my client's Learning Management System. I run this script once a week to add new users.
The Problem: As well as adding new users, I need to deactivate users who have left. Whenever someone leaves, my client adds them to an OU called LEAVERS, which is a column in my spreadsheet. However, I have no way of sorting the spreadsheet by the date a user was added to the LEAVERS OU.
The Question: Is there a way I can compare a spreadsheet from one week with a spreadsheet from another week to identify new rows that have been added? I'm thinking that if I filtered so only users that are in the LEAVERS OU show, then if I could identify new rows, that would be great.
I can't see how that would be possible, but I thought I'd ask in case there's another solution that anyone can think of. Thanks for your time!