Macro for drop down list options with different increases

[Tona]

I have a master sheet in which I input my data (A7:D). In cell C2 I want to have a dropdown list with few options (A, B, C, No changes).

When I choose particular option (eg. A) macro should select the range of input data (A7:D) and multiply columns C7:C and D7:D with correspondent increase. Let's say if I choose option A it should increase column C by 10% and column D by 7%. If I choose option C it should increase/multiply column C by 12% and column D with 0% increase...And so on different criteria for each option.

There should also be an option in drop down list which would mean "No changes", because I have another macro that copies existing data on second sheet and the master sheet has to be "clean" for next inputs.

Thank you for suggestions!

[naveenmarapaka]

Hello, some what understood .. but not quiet clear ... can you explain more in figure , what output should look like in excel....

like what 10% increase you want, the value / width of column ?


regards

[Tona]

I want 10% increase in value, so values in column C7:C multiplied by 1.1, etc...

[naveenmarapaka]

Hi Look at the attached , hope this is your requirement ....

[Tona]

Hi,

what is the logic behind?

I have to have the "no changes" option which returns values on the "starting ones" (without any changes in increase).

Thanks

[naveenmarapaka]

you mean, it should go back to the starting values if you select No changes ??

[Tona]

Yes, exactly!

How does it work?

[naveenmarapaka]

Check now...

[Tona]

Thank you, works on example!

I would appreciate the logic behind so I can apply it on my documents and adjust the criteria.

[naveenmarapaka]

Press Alt F11 , then select Sheet1 code, and also This workbook code.. you will know the logic....

Basically an Array will store the intial values which is declared public.. then when ever you select No changes, it will post the same values in that...
So Note it. again,,, What ever your values displayed initially when you open workbook, that will be the values which will be stored in array.....

[naveenmarapaka]

Press Alt F11 , then select Sheet1 code, and also This workbook code.. you will know the logic....

Basically an Array will store the initial values which is declared public.. then when ever you select No changes, it will post the same values in that...
So Note it. again,,, What ever your values displayed initially when you open workbook, that will be the values which will be stored in array.....