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:

Carlsberg

Carlsberg

Carlsberg

ISS A/S

ISS A/S

ISS A/S

ISS A/S

ISS A/S

ISS A/S

H. Lundbeck A/S

H. Lundbeck A/S

H. Lundbeck A/S

H. Lundbeck A/S

FLSmidth & Co.A/S

<tbody>
</tbody><colgroup><col></colgroup>

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.