copy information with vba

[Rhekan]

Dear all,

I try to copy data from 1 worksheet into another depending on a certain value:

The worksheet "main" contains information regarding supplier name + country + different categories. For each categorie the supplier can get a value.
The worksheet "filter" got a cell where a certain value e.g. "55" can be put in. After typing in the value, I would like to get a list where the categories are listed below and the value is listed in a single cell.

I uploaded an example and hope that someone can help me.

[georgiboy]

Like on the attached?

[arnelgp]

you may also try this.