Dynamic tab for offer

Hello everybody

I am relatively new to VBA and would like to use some of the benefits. I have a hard time to set up a dynamic tab for an offer that takes information from a table with information of a second tab (See Excel for example).

One tab is dynamic (Tab "Offerte") and should take text and numbers from a second tab (Tab "Berechnung"). The user will put in numbers (1,2,3,4) in column A in the tab "Berechnung" at each row that is required. This will trigger the text and the price in this same row and show it in the tab "offerte". It should be possible to take only one row, but also several rows and copy that information to the dynamic tab. It is a bit difficult to explain, but I think in the Excel it should be clear.

The idea is to have a large table of information in tab "Berechnung" where the user can choose from. The second tab is a kind of offer letter and should show the information selected from the tab "Berechnung" and calculate a price in the end.

I appreciate any kind of help and support. If you wonder or dont understand all the text, it is in German.

Thanks a lot!
Lukas

Thanks for your feedback. I think, a dropdown menu is not suitable because the table in tab "Berechung" will be much larger than the example I have shown in the Excel. Additionally, the user will have to enter certain parameter that will caculate the price. I didn't show this to make the example easier.

I think, the dynamic tab that takes information from the tab "Berechnung" is the more user-friendly way.

Does that make sense?

Lukas