Rhekan
08-31-2022, 06:44 AM
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.
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.