+ Reply to Thread
Results 1 to 4 of 4

Sheet recalculates based on item selected on drop-down box?

  1. #1
    Registered User
    Join Date
    04-18-2014
    Location
    USA
    MS-Off Ver
    MS Office 2010
    Posts
    86

    Sheet recalculates based on item selected on drop-down box?

    Hi guys how is everyone today? I have a small favor (or maybe big depending on how much work it is). I have no idea on how to program for excel and I'm curious if someone could help write a code that lets a sheet recalculate based on a item selected from a drop-down box?

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Sheet recalculates based on item selected on drop-down box?

    There is no need for any programming here.

    In the attached sheet I created a drop down list in Cell A1

    That drop down uses a table on the same sheet but it could have been in the cell itself

    Changing the data in cell a1 causes cell c1 to calculate.
    Attached Files Attached Files
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

  3. #3
    Registered User
    Join Date
    04-18-2014
    Location
    USA
    MS-Off Ver
    MS Office 2010
    Posts
    86

    Re: Sheet recalculates based on item selected on drop-down box?

    Thanks for the quick response. I should attach a sheet to help better show what I'm talking about which ill have to do later as I'm AFC right now.

  4. #4
    Registered User
    Join Date
    04-18-2014
    Location
    USA
    MS-Off Ver
    MS Office 2010
    Posts
    86

    Re: Sheet recalculates based on item selected on drop-down box?

    Ok sorry it took so long been pretty busy but here are a few of the sheets that I would like to be selectable from one sheet. There are 2 more sheets I also need to add but its just 2 more Bag Of Holding Type (next number). If someone would so kindly please help me figure this out I would greatly appreciate it.

    Bag Of Holding Type 1.xlsx Bag Of Holding Type 2.xlsx Handy Haversack.xlsx

+ 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. Run macro when item from drop-down list is selected
    By barnett2000 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-09-2013, 12:52 PM
  2. Replies: 2
    Last Post: 01-30-2013, 03:16 AM
  3. [SOLVED] Link to item (row) selected in drop down (data validation)
    By stlchristy77 in forum Excel General
    Replies: 3
    Last Post: 06-26-2012, 03:07 PM
  4. How to get index of selected item in drop down list?
    By nleahcim in forum Excel General
    Replies: 3
    Last Post: 08-08-2011, 02:08 PM
  5. Calculate Based on Drop Down Item Selected
    By JenB in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-18-2006, 12:45 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