We have 1 excel workbook with multiple sheets.
To know what software is installed on all computers in my company, we run a software report.
We copy this report to the Excel workbook.
So basically we have about 50 rows per computer. Per row, there's a software program listed.
The problem is that we need to filter out the software that is not standard.
All the default software is listed in the first sheet called: Standard_Software
What we need is:
A macro that looks at column B in the sheet 'Standard_Software" and remove the rows on any other sheet in the workbook that contain the exact same. name.
In this way, the rows that are left over will contain software that is NOT listed in the sheet 'default_software'.
Workbook in attachment