Greetings,
My manager wants departing employees at my company to be tracked in a specific format via excel document. Instead of manually typing everything in, I'd like to wow this person by using a query from active directory in microsoft excel to pull this information.
My current testing query is set up so that when I enter the employee ID number in column A, there are serveral VLOOKUP formulas used to populate subsequent columns in the same row with employee first and last name, office location, computer serial number, etc. All this data is being pulled from a separate sheet within the same excel document, where my active directory query data resides.
The problem I'm encountering while tinkering with this functionality is that once an employee leaves and a few weeks have elapsed, the active directory object is deleted and I'm left staring at a blank row where my excel data USED to be.
Can anyone shed some light on what I'm doing wrong here? I'd like data to remain in my sheet even if an active directory user object is deleted.
Thank You for any tips/pointers.
Anthony
Bookmarks