Results 1 to 17 of 17

Need Macro to calculate cost when user select an option

Threaded View

HarryC Need Macro to calculate cost... 02-28-2017, 07:47 AM
HarryC Re: Cost calculator -... 02-28-2017, 10:25 AM
HarryC Re: Cost calculator -... 02-28-2017, 12:16 PM
philaugust2004 Re: Cost calculator -... 02-28-2017, 12:52 PM
HarryC Re: Cost calculator -... 03-01-2017, 06:32 AM
HarryC Re: Cost calculator -... 03-01-2017, 08:54 AM
skyping Re: Cost calculator -... 03-01-2017, 02:03 PM
protonLeah Re: Cost calculator -... 03-01-2017, 06:45 PM
protonLeah Re: Cost calculator -... 03-01-2017, 07:39 PM
6StringJazzer Re: Cost calculator -... 03-01-2017, 09:21 PM
HarryC Re: Need Macro to calculate... 03-02-2017, 04:25 AM
HarryC Re: Need Macro to calculate... 03-02-2017, 05:17 AM
skyping Re: Need Macro to calculate... 03-02-2017, 07:45 AM
HarryC Re: Need Macro to calculate... 03-02-2017, 08:34 AM
skyping Re: Need Macro to calculate... 03-02-2017, 05:33 PM
HarryC Re: Need Macro to calculate... 03-09-2017, 07:46 AM
skyping Re: Need Macro to calculate... 03-09-2017, 03:10 PM
  1. #1
    Registered User
    Join Date
    09-09-2013
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    40

    Need Macro to calculate cost when user select an option

    Hello
    I want to build a template where i have various options in tiles that a user can pick and then chose categories underneath the particular option which will have a cost set and then picking various categories will calculate cost.
    In a perfect example just how we chose our tv packages.

    So, for example -
    I have a one of the master category called "Resilience" . there will be various other master categories.
    if user clicks on "resilience", underneath it, it gives various options to chose. Example SPOF, 2 DC Manual, 2 DC Auto. I want user to see the definiton of each
    And then allow user to pick any of the above. (behind these there are cost for example SPOF - $100, 2 DC Manual - $200, 2 DC Auto - $300)
    and if the user select any of the option, there is a sum total at the bottom which is calculating the cost.

    Hope i have managed to explain what i would like excel to do and hope it is simple

    Thanks again
    Harry
    Last edited by HarryC; 03-02-2017 at 04:23 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Cost Comparison Calculator
    By kgkgkg9009 in forum Excel General
    Replies: 4
    Last Post: 10-12-2016, 02:28 PM
  2. Cost Price Calculator
    By Martinchaplin in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-20-2015, 05:11 PM
  3. Cost calculator
    By chairmaker in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-07-2015, 08:51 AM
  4. Cost Calculator basis day / hour
    By splintered in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-25-2013, 07:43 PM
  5. Building a cost calculator
    By Dusty Strings in forum Excel General
    Replies: 2
    Last Post: 06-01-2011, 10:02 AM
  6. carpet cost calculator
    By MikeDean in forum Excel General
    Replies: 5
    Last Post: 12-03-2007, 05:50 PM
  7. Cost Calculator
    By bnwash in forum Excel General
    Replies: 1
    Last Post: 04-20-2007, 05:08 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