Hi Morten

Why not use DataFilterAutofilter and use the dropdown on column C to
select September.

Regards

Roger Govier


Morten wrote:
HI all

I need some help with this one.

I have a long list with investments which look like this:

A B C

Cars:

A6 40.000 September
Megane 35.000 September
A4 30.000 Oktober

Other:

Tool 10.000 December

and so on....

In a new sheet i want to write "september" in A1 and then all the rows with
"september" in the C column shall appear.

Is this possible