Showing a group of cells dependent on drop selection

[terrox]

Hi
First time here
I'm building a calculator for my company which contains many products that have multiple options
Was wondering if possible to make it on one page with drop list that will show only the group of cells that are relevant to the selection (some sort of iFrame - which can be also modified) - Image attached to explain better.

Thank you!

 

[mumps]

The macro below is based on how your data is organized in your screenshot. If your actual data is organized differently, the macro may not work as expected. Copy and paste this macro into the worksheet code module. Do the following: right click the tab for your sheet and click 'View Code'. Paste the macro into the empty code window that opens up. Close the code window to return to your sheet. Make a selection in cell N2.

Private Sub Worksheet_Change(ByVal Target As Range)
    If Intersect(Target, Range("N2")) Is Nothing Then Exit Sub
    Dim foundVal As Range
    Set foundVal = Columns("B:H").Find(Target, LookIn:=xlValues, lookat:=xlWhole)
    If Not foundVal Is Nothing Then
        foundVal.CurrentRegion.Copy Cells(Target.Row + 2, Target.Column)
    End If
End Sub