+ Reply to Thread
Results 1 to 2 of 2

code to alter 3 cells through range of % reductions and paste dependant cell results

  1. #1
    Registered User
    Join Date
    07-28-2010
    Location
    london, england
    MS-Off Ver
    Excel 2007
    Posts
    91

    code to alter 3 cells through range of % reductions and paste dependant cell results

    I have a cell which gives the result of a model which is fed by numerous variables. One of which is the price of a product. I'm looking to evaluate the impact of percentage discounts from 1% to 100% without manually changing the price cell each time.

    Ideally the code would create an output table of % discount and copy and paste result cell value.

    i.e:

    1% £10,000
    2% £9,990....

    This is hard to explain so I have attached a simplified spreadsheet where the cells which need changing are C5:C7 and the result cell is I5.

    Many Thanks,
    James
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    06-26-2010
    Location
    Austin, TX
    MS-Off Ver
    Excel 2010
    Posts
    1,673

    Re: code to alter 3 cells through range of % reductions and paste dependant cell results

    I am failing to understand why you don't just create your own column with the percentages and then an equation using the price and the percentages. If you want to get really fancy, you could use a 'Data Table'.
    Pauley
    --------
    If I helped with your issue, I'd appreciate a rep bump (hit the '*' icon to the bottom left of this post).

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Alter" VLOOKUP" code to run Cell by Cell not on entire range
    By capson in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-04-2015, 06:20 PM
  2. [SOLVED] Alter Code for Copy and Paste of Data to Created New Sheets.
    By Ortz in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-04-2014, 10:32 PM
  3. [SOLVED] Colour range of cells dependant on value of a cell VBA
    By ThomasCarter in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-05-2012, 04:26 PM
  4. Replies: 2
    Last Post: 04-05-2012, 08:22 AM
  5. Alter value in one cell alter value in multiple cells
    By Bryan Noqw in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 03-11-2008, 05:31 AM

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