1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Dropdown's Combination Display

Discussion in 'VBA Macros' started by Deepak Sharma, Jul 11, 2018.

  1. Deepak Sharma

    Deepak Sharma Member

    Messages:
    148
    Hi Everyone,

    I got stuck in-between, would need your help. Actually, I have Three Drop downs, I after choosing them the data should display in Chart.

    Please see the attached sheet for more clearance.

    1 If B1 = "All" & E1 = "All" - Then chart should reflect all values as per the Range i.e. A7 to B12
    2 If I select any BU in cell B1 and all in E1 - then it should reflect all insurers values UNDER that BU.
    3 If I select any BU in cell B1 and any Insurer in E1 - then it should reflect all related values UNDER that BU & Insurer
    4 I also need to connect Cell H1 (Month) from the Data sheet's column no. 16. WITH ALL THE ABOVE CONDITIONS.

    Thanks and Regards,

    Attached Files:

  2. Deepak Sharma

    Deepak Sharma Member

    Messages:
    148
    Can anyone answer this Please...???
  3. vletm

    vletm Excel Ninja

    Messages:
    3,674
    Deepak Sharma
    Take care that
    'Chart'-sheet' A-column values match with 'Data sheet' AA-column values.
    Now, there are challenges.
    I didn't test all variations...
    but Month-selection will work ... if this years dates!

    Attached Files:

  4. Deepak Sharma

    Deepak Sharma Member

    Messages:
    148
    So sorry for late reply vletm, Thank you for your help! This is good though.
    But Can I get a simple SIMFS formula to determine the things... I have the formula attached in sheet but need to consolidate "All" conditions also for all three fields i.e. "B1", "D1" & "H1".


    Thanks & Regards,
  5. vletm

    vletm Excel Ninja

    Messages:
    3,674
    Deepak Sharma
    What is missing?
    Of course, You can write somewhere SIMFS ... or what ever ... but no need!
    Did You even try to use all those selection combinations?
    ... and case 'H1' works so far only with current YEAR.
  6. Deepak Sharma

    Deepak Sharma Member

    Messages:
    148
    Hi Vletm, Yes I tried this. your CODE is absolutely fine, no issues with that. The only thing which I am facing is the Eff. Date issue which is from my side. When compiling the data on Data Sheet, the format which is pasting in Col. 16 is in double format, in some cells its in mm/dd/yyyy format and somewhere it's in dd/mm/yyyy format. I seriously don't know how to come over to it.
    That's the main concern actually now.

    Regards,
  7. vletm

    vletm Excel Ninja

    Messages:
    3,674
    Deepak Sharma
    hmm ... before paste something ... You should check what are You doing.
    eg If date is 04/12/2018 .. is it from April or December? You should know that!
  8. Deepak Sharma

    Deepak Sharma Member

    Messages:
    148
    Yes, you are right sir, Could you please remove the third condition i.e. Date column from these calcs. I have tried it but not successful.
    Need to remove it because date format is not correct actually.

    Regards,
  9. vletm

    vletm Excel Ninja

    Messages:
    3,674
    The third condition will work only, if selection is other than "All".

Share This Page