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 Mark. Sorry I am a novice. Where do you enter the Jan formula? Is Jan a name for the range?

Jan = your formula for B4 january
Feb = your formula for B4 feb
Mar = your formula for B4 mar
apr = your formula for B4 apr

 

[MarkCBB]

HI there,

If you have a look at the end of the formula:

=CHOOSE(VLOOKUP($A4,{"January",1;"February",2;"March",3;"April",4;"May",5;"June",6;"July",7;"August",8;"September",9;"October",10;"November",11;"December",12},2,FALSE),Formula for Jan,Formula for feb,Formula for mar,Formula for Apr,Formula for may,Formula for jun,Formula for jul,Formula for aug,Formula for oct,Formula for nov,Formula for dec)


just replace the "Formula for jan" with the formula for January.

 

[mobile63]

Hi Mark. Sorry I am a novice with formulas. Where do I enter my (rows) formulas and how do I link the cells. I see the refence for A4 but not the reference for B4. Thanks

 

[MarkCBB]

Please send me the formulas will be ebtered into B4,C4,D4,E4, etc to M4, for january

 

[mobile63]

Hi Mark,

C4 1200<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
D4 15%<o></o>
E4 =+C25*D25<o></o>
F4 =+C25-E25<o></o>
G4 =+F25-(F25*$D$25)<o></o>
H4 =+G25-(G25*$D$25)<o></o>
I =+H25-(H25*$D$25)<o></o>
J =+I25-(I25*$D$25)<o></o>
K =+J25-(J25*$D$25)<o></o>
L ==+K25-(K25*$D$25)<o></o>
M =+L25-(L25*$D$25)<o></o>
It is a financial calculation - depreciation

Thank you

 

[MarkCBB]

HI there,

what is the differance between the formulas for January and the other months? I see you left B4 out, is there a reason why?

 

[mobile63]

Hi Mark, Sorry, B4 is only a "text note cell" , Yes it is a difference between months in % rates. Thanks

 

[Michael M]

Are you saying, all cells have the same formula except "D4" ?
If this is the case, it's the only one that needs to change, all the rest are static and could be input directly to the sheet at the beginning. You could then probably use a simpler version of Marks CHOOSE formula, for the D4 change.

 

[mobile63]

Hi Michael, Thank you for your suggestion. I will have two variables, first is the time in years, and second the % procentage. At the moment I am copying the rows, trying to use absolute cells, then I am checking the calculations manually (made a template). Sometimes I detect mistakes in calculation. I tought that if I can have a drop down list conected to each specific calculations/rows and then I will lock the cells, and I can avoid miscalculations. Thanks. Regards Stefan

 

[Michael M]

Stefan you could also use a Worksheet change event to do the same thing.....but if you are staying away from VBA then so be it.
Which cell is the time in years in ?