Create a drop down menu and auto function

[Fischer]

Hi everyone. I'm new here and I hope you guys can help me I'm just started working with macro and I hope it can solve my problem.
I'm using the worksheet to calculate prices.

I want to create a drop down menu to make a selection of the item I'm going to calculate on. (column A in the picture below)
After that I want to take the data from the cells to be set next to each other and create the header in the cell above. (From column D19 to column O19)
It should repeat by any selections.

help 2.jpg

The resolved should like this picture.
help.PNG

I hope my description of the problem is good enough

BR.
Dennis Larsen

[FDibbins]

Hi and welcome to the forum

Rather than post pictures - which are impossible to edit/work with, upload your sample workbook

[Fischer]

Thanks I just uploaded the workbook sample

[kvsrinivasamurthy]

Pl see the file attached with formulas.

[Fischer]

Thank you so much, it was just what i needed Amazing work, thank you