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.

VBA Macro For Configuration

Discussion in 'VBA Macros' started by devendra.dvm, Feb 27, 2017.

  1. devendra.dvm

    devendra.dvm Member

    Messages:
    148
    Hi Experts,



    Please help me with VBA Macro to configure commission rates..
    Have attached sample for reference..

    In Configure sheet...I have mentioned instruction details and agents
    In output Sheet.. I have mentioned wat is the output will come out after i click upload button in Configure sheet......Hope you will understand the same.

    Thanks in Advance...

    Attached Files:

  2. Monty

    Monty Well-Known Member

    Messages:
    833
    Hey Dev..

    Not so clear!
    Arpanakumar and jamesexcel1970 like this.
  3. Monty

    Monty Well-Known Member

    Messages:
    833
    Please confirm the format below is it as per your requirment and also let me know what you are looking for?
    upload_2017-2-28_0-43-4.png
  4. Monty

    Monty Well-Known Member

    Messages:
    833
    Dev!

    Little change in the format for easy reading

    upload_2017-2-28_0-48-34.png
  5. jamesexcel1970

    jamesexcel1970 Member

    Messages:
    85
    Wow Monty, Onces again you are ready with frame.
    devendra.dvm and Monty like this.
  6. devendra.dvm

    devendra.dvm Member

    Messages:
    148
    Hi Monty Thanks for your quick response...

    Please refer the below image for the same.

    upload_2017-2-28_10-4-58.png

    Attached Files:

  7. devendra.dvm

    devendra.dvm Member

    Messages:
    148
    Hi James,

    Hope you also will understand wat is my requirement with references which i have provided..

    Thanks in advance.
  8. Monty

    Monty Well-Known Member

    Messages:
    833
    Dev.
    Did you chk the format provided.?
    You don't' have time it seems to explain...asking us to refer image..Which we hardly understand.
    Last edited: Feb 28, 2017
  9. devendra.dvm

    devendra.dvm Member

    Messages:
    148
    Yes Monty...

    Have checked the format and that's the reason i have posted images for your reference..
    It's not that i don't have time.
    I Have explained the same in that screenshot..you can see that i wrote in highlighted cells.
  10. Monty

    Monty Well-Known Member

    Messages:
    833
    Quick question.

    When i select one agent you wanted to show as output 3 rows as per the broker id table?
  11. devendra.dvm

    devendra.dvm Member

    Messages:
    148
    yes..

    if u select one agent with scheme TR
  12. devendra.dvm

    devendra.dvm Member

    Messages:
    148
    in the same way if u select scheme MM output will be in 7rows
  13. Monty

    Monty Well-Known Member

    Messages:
    833
    Please confirm it.

    MM ->7 rows
    FS -> 7 rows
    TR-->3 rows

    if you select one agents then total rows to be displayed would be 17 rows.
  14. devendra.dvm

    devendra.dvm Member

    Messages:
    148
  15. devendra.dvm

    devendra.dvm Member

    Messages:
    148
    Hi Monty

    hope your online now.
    Last edited: Feb 28, 2017
  16. devendra.dvm

    devendra.dvm Member

    Messages:
    148
    Hi Monty.

    Pls respond..thank You..
  17. Monty

    Monty Well-Known Member

    Messages:
    833
    Hey Dev.

    Sorry to keep you in waiting.

    Still working on it and even busy with office work too..

    may be need to buy some time from you.
  18. devendra.dvm

    devendra.dvm Member

    Messages:
    148
    Tkank you Monty...
  19. devendra.dvm

    devendra.dvm Member

    Messages:
    148
    Hi Monty.

    Hope you will come to online today...
  20. devendra.dvm

    devendra.dvm Member

    Messages:
    148
    Hi Monty.

    Pls respond.
  21. Monty

    Monty Well-Known Member

    Messages:
    833
    Still trying my level best to get the output into shape but unsuccessful..let me keep trying...need to buy time again.
    jamesexcel1970 and Arpanakumar like this.
  22. devendra.dvm

    devendra.dvm Member

    Messages:
    148
    Thank you Monty.

    Sorry to bug you again about this.
  23. devendra.dvm

    devendra.dvm Member

    Messages:
    148
    hi Monty.

    Hve found any solution..?
  24. Monty

    Monty Well-Known Member

    Messages:
    833
    Still Unsuccessful after many test....Not really sure to crack it..
  25. devendra.dvm

    devendra.dvm Member

    Messages:
    148
    Hi Monty

    Thanks for reply....Hope you will crack it...:(

Share This Page