Determine perpetual occurance of item(s) from multiple worksheets

[nai0248]

I receive a monthly report of a network scan that contains patch requirements for random computers on a network.

I want to use these individual monthly reports and compare them to each other to determine repeated instances of a patch appearing in the scan (patch not installed).

I have worked with Pivot Tables in the past but this one is beyond my skills. I've seen suggestions to consolidate the date and create a pivot table based on the consolidation and/or create a VBA to run a SQL Union on the multple files.

Anyone have other ideas or a idiots guide to performing the steps above?

An example would be:
File One:
computer 1, Patch1
computer 1, Patch2
computer 1, Patch3
computer 2, Patch2
computer 2, Patch3
comptuer 2, Patch4

File Two:
computer 1, Patch2
computer 1, Patch3
computer 1, Patch4
computer 2, Patch2
computer 2, Patch3
comptuer 2, Patch5

Output:
Computer 1, Patch2
Computer 1, Patch3
Computer 2, Patch2
Computer 2, Patch3

[davesexcel]

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

[mahju]

From your result it seems that patch found in both file (common) is needed. you can use vlookup function. It can be used on multiple Workshets.


see attached for help

Vlookup and vlookup-1 are two files and vlookup file has formula entered

You can use copy + paste special - values to convert the list to values for further processing.

Regards