devendra.dvm
Member
Hi friends.
I’m working in stock broking company, I am into commission processing, Every month I need to configure commission structure for multiple Agents (code)
So I want to simplify the process as I am working on weekends also for the same.
Scheme: MR
Plan: w
Agent: ARN-3077
Agent Category ID: 1003
Brok Type ID: 1
From Date: 01/01/2017
To Date: 31/03/2017
From Amount: 0
To Amount: 9999999999999.99
Rate: 1.5
Remarks: Ltr.21789.Dtd.01.02.2017
City Category: B-15
frommonth: 366
tomonth: 1095
This is the format for the for configuring commission rate. After creating excel file will upload the same in one application.
Please any one help on the same and create a macro(User form to enter the data) to automate the same.. my requirements is as below
Suppose If I want to configure commission structure to 100 agents.. 1st I will upload all agent id’s and then I will enter remaining parameters shown in above table after entering all parameters I want an option in user form to choose to select Agent code. After choosing agent code I will hit enter and all fields should get clear so that I will update all fields again with different scheme code.. after finishing I want finish button to hit and all the data get export one excel file…
Please create one user form as per my requirements....Thank you
please ignore grammar mistakes.
I’m working in stock broking company, I am into commission processing, Every month I need to configure commission structure for multiple Agents (code)
So I want to simplify the process as I am working on weekends also for the same.
Scheme: MR
Plan: w
Agent: ARN-3077
Agent Category ID: 1003
Brok Type ID: 1
From Date: 01/01/2017
To Date: 31/03/2017
From Amount: 0
To Amount: 9999999999999.99
Rate: 1.5
Remarks: Ltr.21789.Dtd.01.02.2017
City Category: B-15
frommonth: 366
tomonth: 1095
This is the format for the for configuring commission rate. After creating excel file will upload the same in one application.
Please any one help on the same and create a macro(User form to enter the data) to automate the same.. my requirements is as below
Suppose If I want to configure commission structure to 100 agents.. 1st I will upload all agent id’s and then I will enter remaining parameters shown in above table after entering all parameters I want an option in user form to choose to select Agent code. After choosing agent code I will hit enter and all fields should get clear so that I will update all fields again with different scheme code.. after finishing I want finish button to hit and all the data get export one excel file…
Please create one user form as per my requirements....Thank you
please ignore grammar mistakes.