VBA Macro For Configuration

[devendra.dvm]

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...

 

[Monty]

Hey Dev..

Not so clear!

 

[Monty]

Please confirm the format below is it as per your requirment and also let me know what you are looking for?

 

[Monty]

Dev!

Little change in the format for easy reading

 

[jamesexcel1970]

Wow Monty, Onces again you are ready with frame.

 

[devendra.dvm]

Hi Monty Thanks for your quick response...

Please refer the below image for the same.

 

[devendra.dvm]

Wow Monty, Onces again you are ready with frame.

Hi James,

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

Thanks in advance.

 

[Monty]

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.

 

[devendra.dvm]

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.

 

[Monty]

Quick question.

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

 

[devendra.dvm]

yes..

if u select one agent with scheme TR

 

[devendra.dvm]

in the same way if u select scheme MM output will be in 7rows

 

[Monty]

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.

 

[devendra.dvm]

yes.

 

[devendra.dvm]

Hi Monty

hope your online now.

 

[devendra.dvm]

Hi Monty.

Pls respond..thank You..

 

[Monty]

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.

 

[devendra.dvm]

Tkank you Monty...

 

[devendra.dvm]

Hi Monty.

Hope you will come to online today...

 

[devendra.dvm]

Hi Monty.

Pls respond.

 

[Monty]

Still trying my level best to get the output into shape but unsuccessful..let me keep trying...need to buy time again.

 

[devendra.dvm]

Thank you Monty.

Sorry to bug you again about this.

 

[devendra.dvm]

hi Monty.

Hve found any solution..?

 

[Monty]

Still Unsuccessful after many test....Not really sure to crack it..

 

[devendra.dvm]

Hi Monty

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