Drop down list attached to specific row

[mobile63]

Hi Guys, I need help. I would like to optimise my drop down list/box. by attaching a row of 10-20 cells of calculations to each selection from the drop down list. For example if I choose a month like February than I would like to populate the row with calculations for February, if I choose August then the August calculation row will appear.

 

[mobile63]

Hi Michael. It will be B4. which could be linked to D4, as the time/years could give the %. Regards Stefan.

 

[Michael M]

So, "A4" will have the chosen month and then you will input a number in "B4" and the No of years in "D4" ?
All the other cells have a fixed formula ?

 

[mobile63]

Hi Michael, There are two types of formulas.
Straight line and diminishing. I cannot use the Excel depreciation formulas as they have a "salvage value". I can play and buildup the calculation, my big problem is to attach the calculated (row) cell range to the drop down list.
Regards and Thanks Stefan.
Sorry most of the formulas in cells are the same

 

[Michael M]

Stefan
Refer Post #3
I don't think you are going to get the simple answer you are looking for, ie, a formula
With the correct information provided for each cell in the range, I believe you will have to use a Select Case Macro. A sample is below, but obviously the formuale and refernces will have to be corrected to suit.

Also, it might help if you post a sample of your workbook with what you have and what you would like as a result.
See the 2nd line of my tag for Excel HTML maker to copy and paste samples to this forum

Sub Worksheet_selectionChange(ByVal Target as Range)
Dim target As String
target = Cells(4, 1)
Cells(4, 2).Formula = "INPUT"
Cells(4, 3).Formula = "INPUT"
Cells(4, 4).Formula = "INPUT"
Cells(4, 5).Formula = "= C25 * D25"
Cells(4, 6).Formula = "= C25 - E25"
Cells(4, 7).Formula = "=F25-(F25*$D$25)"
Cells(4, 8).Formula = "=G25-(G25*$D$25)"
Cells(4, 9).Formula = "=H25-(H25*$D$25)"
Cells(4, 10).Formula = "=I25-(I25*$D$25)"
Cells(4, 11).Formula = "=J25-(J25*$D$25)"
Cells(4, 12).Formula = "=K25-(K25*$D$25)"
Cells(4, 13).Formula = "=L25-(L25*$D$25)"

Select Case target
    Case "January"
     Cells(4, 3).Formula = ""
     Cells(4, 4).Formula = ""
    Case "February"
        Cells(4, 3).Formula = ""
        Cells(4, 4).Formula = ""
    Case "March"
        Cells(4, 3).Formula = ""
        Cells(4, 4).Formula = ""
    Case "April"
        Cells(4, 3).Formula = ""
        Cells(4, 4).Formula = ""
    Case "May"
        Cells(4, 3).Formula = ""
        Cells(4, 4).Formula = ""
    Case "June"
        Cells(4, 3).Formula = ""
        Cells(4, 4).Formula = ""
    Case "July"
        Cells(4, 3).Formula = ""
        Cells(4, 4).Formula = ""
    Case "August"
        Cells(4, 3).Formula = ""
        Cells(4, 4).Formula = ""
    Case "September"
        Cells(4, 3).Formula = ""
        Cells(4, 4).Formula = ""
    Case "October"
        Cells(4, 3).Formula = ""
        Cells(4, 4).Formula = ""
    Case "November"
        Cells(4, 3).Formula = ""
        Cells(4, 4).Formula = ""
    Case "December"
        Cells(4, 3).Formula = ""
        Cells(4, 4).Formula = ""
End Select
End Sub

 

[mobile63]

Hi Michael, I am very gratefull for your help. Please give me 24 hours, time, to try to understand your advice. Thanks and Regards Stefan

 

[mobile63]

Hi Michael an d Mark,

I had a look at the V & HLOOKUP function, they pick the relavant cell only, Is it possible to pick-up/attach a range of cells? Thanks Stefan