If an ID in one ws exists in another ws, pull all rows with all rows containing the ID

[badlydrunkboy]

Hi,

I have large file which contains a list of every application on every pc (application audit). I have 30+ other files (asset audits) which contain information about who uses each PC, which room they're in, their email address etc, split into teams. For example, Asset Audit 1 is a workbook containing the information about each member of the Finance team, Asset Audit 2 is another workbook containing the same information but for HR team.

What I would like to create is another worksheet in the asset audit files which contains the PC name, the user and the building and room number of where they are sat from the asset audit as well as every application (Software Manufacturer, Product and Product Version) which exists on that pc from the application audit file. So in the example files, i'd like the macro to look for the value in Asset Audit 1, column E and bring back all matches for it from the Application Audit workbook and populate the Application Audit tab in the Asset Audit workbook. I hope that makes sense.

Many thanks in advance