Results 1 to 11 of 11

Macro for drop down list options with different increases

Threaded View

  1. #1
    Forum Contributor
    Join Date
    10-17-2014
    Location
    EU
    MS-Off Ver
    2013
    Posts
    114

    Macro for drop down list options with different increases

    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!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. drop down list with options
    By kayye in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-03-2013, 12:06 PM
  2. [SOLVED] Column B drop down list with 2 options, columns C & E with dependent drop down lists
    By betic in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-26-2012, 03:47 PM
  3. Drop down list options
    By James83 in forum Excel General
    Replies: 10
    Last Post: 04-23-2011, 07:13 PM
  4. Take away options in drop-down list
    By phiberjenz in forum Excel General
    Replies: 0
    Last Post: 04-16-2009, 04:44 AM
  5. [SOLVED] My Excel drop-down list eliminates from list options chosen. Help
    By Sybil in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-19-2006, 05:25 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1