Excel 2013: VBA to find all cells with duplicate ID text and dump cell contents to 2nd sheet -

Not sure that the title is very clear

Actually, I have this column in column B There are approximately 500 rows that include the Nessus vulnerability scan data. The main element is "Plugin ID: ######" The text is attached to a set of some column above, the plugin ID / vuln hosts.

Some plugin IDs occur multiple times in 500 rows, however, this data is temporary (month to month) because we do new scans, sometimes it is fixed on the old host but for some reasons From the new host to that vulnerability, and sometimes it is a mixture (many hosts will be certain, not the other, new hosts come with the same problem)

(B) Plugin ID: 123456 ( J) Server 1, Server 2, Server 3

.

(B) Plugin ID: 123456 (J) Server1, Server2

I have to do a VBA function which takes the Plugin ID from each cell in column B and the remaining B For duplicate B.B., and then copy the column B cell and its line contents to the original from column J and duplicate it in a new sheet, in this way I can eyeball and set up the lines which have been installed in NESUS Has been done accordingly.

It is the same, I can do this manually by filtering it, but it is slow and serious

Where should I start? I am always trying to decide whether I should do old school VBA functions or use some new Excel built in VBA functions and tools.

Why VBA? Just use COUNTIF to check how many times the ID has been duplicated and filter the formula column for the rows with numbers> 1. Sort the ID column so that repeated rows appear next to each other.

For example

  = COUNTIF (b $ 3: b $ 7; b3)