VBA code - data extraction from table in word by criteria

[nusida85]

Hi guys,

I have a series of 100 tables in MS Word like this one:

[TABLE="width: 630, align: center"]
<tbody>[TR]
[TD] HD
[/TD]
[TD]Internet-of-Things (IoT) Market Innovation Producing Immense Growth Potential
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD] CR
[/TD]
[TD]Marketnewsupdates.com; PR Newswire
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD] WC
[/TD]
[TD]1,601 words
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD] PD
[/TD]
[TD]28 March 2018
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD] ET
[/TD]
[TD]13:45
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD] SN
[/TD]
[TD]PR Newswire Europe
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD] SC
[/TD]
[TD]TWOTEN
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

I want to populate an excel sheet with the data in the second columns but after searching for the identifiers in the first column.

Example: If a table has 'HD', then copy and paste the corresponding cell in excel, and so on.

I would be really grateful if you could help me out - it is for my student project.

Thanks