Copying different names from one collumn.

[Vilus]

Good evening everyone,

I've just started working with Excel VBE and I've ran into a problem.

I need a VBE solution to copy certain data from a collumn. For example a collumn looks like this:

[TABLE="width: 114"]
<tbody>[TR]
[TD]Carlsberg[/TD]
[/TR]
[TR]
[TD]Carlsberg[/TD]
[/TR]
[TR]
[TD]Carlsberg[/TD]
[/TR]
[TR]
[TD]ISS A/S[/TD]
[/TR]
[TR]
[TD]ISS A/S[/TD]
[/TR]
[TR]
[TD]ISS A/S[/TD]
[/TR]
[TR]
[TD]ISS A/S[/TD]
[/TR]
[TR]
[TD]ISS A/S[/TD]
[/TR]
[TR]
[TD]ISS A/S[/TD]
[/TR]
[TR]
[TD]H. Lundbeck A/S[/TD]
[/TR]
[TR]
[TD]H. Lundbeck A/S[/TD]
[/TR]
[TR]
[TD]H. Lundbeck A/S[/TD]
[/TR]
[TR]
[TD]H. Lundbeck A/S[/TD]
[/TR]
[TR]
[TD]FLSmidth & Co.A/S[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]

In the 2nd, 3rd and other rows there are information which has to be copied along with the name of a brand and pasted in new document or sheet.

Basically I need help figuring out how to tell VBE to differ between names in the collumn so it would copy everything what is related to Carlsberg, ISS A/S and so on and paste it to other sheet/document.