EXCEL how to?
Hi,I hope you guys speak english.
Here my question.
I have groups of information.
Each group contains products
Each product contain categories
Each category contains actions.
It is like a folder structure somehow.
Group 1
Product 1
Product 2
Product 3
Product 4
Product 5
Product 1
Category 1
Category 2
Category 3
Category 4
Category 5
Category 1
Action 1
Action 2
Action 3
Action 4
I would like to be able to have some kind of input box where I enter a group number, push enter
and get all the products in this group. Now, since it would be a bit messy to have also all the categories for all products and their actions, I thought about whether it was possible to click on a product and get then the categories and actions for each category.
Some groups have between 3 and 5 products.
Some products have between 2 and 5 categories
Some products have between 2 and 13 actions.
Does it make sense?
I could pay if anyone wishes to help