Hi,

I am making a calculation form for my work, and I'm stuck at a problem.

I have two sheets, one with the 'database', and one with the actual calculation.
The table in the database has one main type, then multiple entries under that type.

The table on the calculation sheet has the same column headings, except for the type.
What I want, is when I select type via dropdown menu on the calculation sheet, it inserts the whole table under the given type from the databasesheet.
I could do it via an IF-string, but that would me with lots and lots of code, and any change I would do in the database would give me a days work in updating the code on the calculation form.

So, I want the code to be dynamic, so I can add more types as I go along, and the dropdown menu updating to new entries (types)

How can I do this? I've included an example to show you what I mean:
example_excelforum.xlsx

Appreciate any help