Searching rows for specific text in first cell, then copy all rows containing that text

Hi,

I have two sheets in my workbook (sheet A and sheet B).
Sheet B contains data like this ([ ] is a cell):

[Mark 1989][Links][4][Pennen]
[Mark 1989][Midden][4][Pennen]
[Mark 1989][Links][5][Stiften]
[Henk 1939][Links][4][Pennen]
[Henk 1939][Rechts][8][Pennen]
[Henk 1939][Links][2][Stiften]
Etc.

On sheet A I want to have a dropdown-menu or something where I can choose Mark 1989 or Henk 1939 etc.
After selecting one of those I want VBA to copy all rows from sheet 2 of which the first cells contains the text chosen from the drop down menu.

So when I choose Mark 1989 I want VBA to copy

[Mark 1989][Links][4][Pennen]
[Mark 1989][Midden][4][Pennen]
[Mark 1989][Links][5][Stiften]

to sheet A.

Is this possible with VBA?

Are you only after a VBA solution? That could be done with formulae too. Perhaps post a workbook.

Of course it is possoble
exmpl.xlsm

Originally Posted by StephenR

Are you only after a VBA solution? That could be done with formulae too. Perhaps post a workbook.

Yes I prefer a VBA solution!

Originally Posted by lancer102rus

Of course it is possoble

Thanks, works great!