+ Reply to Thread
Results 1 to 3 of 3

Data to display in one cell when specific data from another cell is selected.

  1. #1
    Registered User
    Join Date
    11-05-2015
    Location
    United Kingdom
    MS-Off Ver
    2010
    Posts
    2

    Data to display in one cell when specific data from another cell is selected.

    Hi Guys

    I have a rather specific problem here, I apologize If I have posted this in the wrong part of the forum.

    I am making a table / calculator to calculate total costs over a 24 month period for a paid service (mobile phone service), now there are different levels of service which get different amounts of calls, texts and data.
    Now I have it already set up so you can select the different tariff prices to calculate how much you will pay / tariff price and phone costs combined ect ect, basically all simple addition and multiplication formulas.

    What I want to know is, is there a way that when I select the tariff price the worksheet will then display what tariff I have selected? (how many calls texts and data)
    I have feeling that its possible, I'm just not sure how to go about implementing it.

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    30,771

    Re: Data to display in one cell when specific data from another cell is selected.

    It would help if you could post a small sample file showing expected results and explanation the logic behind any calculations.

    To upload a file:
    "
    Click "Go advanced" the Paper Clip Icon. Then "Add Files" ==> "Browse" (select file) ==> "Upload" then "Done"

  3. #3
    Registered User
    Join Date
    11-05-2015
    Location
    United Kingdom
    MS-Off Ver
    2010
    Posts
    2

    Re: Data to display in one cell when specific data from another cell is selected.

    Thanks for the reply, I have a screen shot of the worksheet for you.

    Excelexample.jpg

    Where the top arrow is is where you select the tariff, there are 8 tariff options (9 including 0)

    Basically when I select a tariff from the drop down list, is there a way for the small table by the bottom arrow to then automatically display the amount of calls, texts and data you get for that tariff?
    for example, the tariff selected would get you 300 Mins of calls, Unlimited texts and 300Mb of data.

+ 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. Replies: 4
    Last Post: 05-14-2015, 02:48 PM
  2. Replies: 5
    Last Post: 04-09-2014, 10:36 PM
  3. Macro to input data on specific cell based on range of another cell data
    By tatisif in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-03-2013, 12:06 PM
  4. Getting mouse selected cell as input to start operations on data of that cell row
    By reach78 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 09-20-2013, 01:48 AM
  5. Display selected value from the user form in a specific cell
    By vignesh805 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-08-2013, 07:32 AM
  6. Replies: 1
    Last Post: 06-22-2012, 02:18 PM
  7. Replies: 2
    Last Post: 05-30-2007, 01:49 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