I have a spreadsheet that is a patch inventory by server (server name in Col A, patch name in Col E).
It is sorted on server name but not necessarily also on patch name. There is one row for each server for each patch - if a server has ten patches applied there will be ten rows for that server.
With data filter I can select a server to see what patches are applied or I can select a patch to see what servers it is on.
I want exactly the opposite of that. I want to select a server to see what patches are not on - or select a patch to see what servers it is not on.
Say that I have 50 servers, each with (the same) 15 patches required.
I envision a master list of servers and a master list of patches.
If I click on a server that has only ten patches applied I would like to see a list containing the 5 patches that are missing
If I click on a patch that is only applied to 40 servers I would like to see a list containing the 10 servers that don't have that patch
One thought is having the two master lists side by side. When clicking a server in the server master list it could search the patches on that server and color code the patches in the patch master list that it finds.
The patch inventory list (the main part of the spreadsheet) will change at least weekly.
The server master list will change, but just occasionally
The patch master list could change daily.
Does anyone have any clues on where to start, or what forum this should go into?
Paul
Bookmarks