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

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

user form(vba macro)

I'm trying, but You (even) don't answer my simply question!
Modified 'output-sheet'...
Screen Shot 2017-02-12 at 18.55.06.png
depends HOW USER select/apply ...
This version do not has any black cells.
 
1) I don't know who is Your 'dear'!
2) It is challenge if You always change Your so called output-layout!
2nd version has black cells and empty rows and 'same rows' again...
3rd version has random color cells without empty rows and 'same rows' again!

Questions:
Do You want those rows twice?
Do You know word 'SORT'?
Do You want black or random cells with those 'text'?
What would be the next version?
Can You answer any questions?
 
i didn't change now...in 2nd version : in that black cells i wrote description for each output(when hit apply agents).. and i keep empty rows to understand because i dont want u to get confuse..
in 3rd version: i just changed color for that black cells.and deleted empty rows..remaining everything is same.


answers for ur questions :

Do You want those rows twice?
Ans: that rows are not repeated..for every row broke type id is different.

Do You know word 'SORT'?
Ans: Yes i know

Do You want black or random cells with those 'text'?
Ans: No i don't want (i just wrote description for your reference)

What would be the next version?
Ans: No next version...this is the final version
 
1) empty rows or not - it's difference! matter of coding!
2) rows twice - humm! - aren't those my colormarked rows same = double?
row 2 = row 21, row 3 = row 20 ... and so on...
Screen Shot 2017-02-12 at 19.44.30.png
3) Then A-column can use as normal way!
4) The Final Version? You ... really want that kind of output?
'upperpart' has rows as applied
and
after that three empty rows (like 14..16rows)
and
after that yellow header 'final output' (like 17row)
after that header row (like 18row)
and
after that one row hidden (19row)
after that sorted rows from above (20 ... rows)
==> Okay ... no problem!
just write 'YES YES'
 
yes your right...thos colored marked rows are double....

from 1st row to 13th row... i just explained what would be the output when hit apply agents(first two conditions in upload)

Note: Sorry for scheme "FS" i forget to change Agent code...

from 1st to 13th row is sample reference for each hit apply agents

from yellow header is final out put
 
Step one: 1 this is my instruction right.

upload_2017-2-12_23-57-12.png



step2: I will configure rates for MM scheme and two agents
so i will pest that agents in apply agents box and i will update rates and other fields in form and i will hit enter
upload_2017-2-12_23-59-47.png


Step 3: After hitting enter out put will be like this for first two agents and for first schemes below image
upload_2017-2-13_0-3-6.png
Step4: nest i will configure rates for second condition in instruction
for scheme FS and 3rd and 4th agents... so i will paste these agents codes in apply agents

upload_2017-2-13_0-5-29.png
 

Attachments

  • upload_2017-2-13_0-2-19.png
    upload_2017-2-13_0-2-19.png
    38.8 KB · Views: 2
hmm ... You didn't answered 'YES,YES' ... hmm?
so so so ...
1) I cannot / don't want to control, how someone would use this!
... then NO NEED those sample rows 1..13? YES or NO?
2) "FS" ... no matter for me, I don't use this!
3) Do You want that
there would be YELLOW header
and
after that hidden row
and
after that sorted rows?
Do previous 'set' start from row 1 or
like in sample ... row 17?
OR
Do You want 'just' those sorted rows from row 2?
4) You name SORT-order!
Write from which column to which column 'output'
>> Many questions again!

5) NOTE! I have tried to ask TODAY many times ...
and I got answer that OUTPUT layout was that challenge!
... is there windy?

and You wanted to use this for 100agents!
and still You drop one-by-one changes!
 
and i will update rates as per instruction for FS scheme and 3rd & 4th Agents and i will hi apply agents.. and output will get export next to "MM" scheme out put as highlighted in below pic

upload_2017-2-13_0-20-8.png

i will repeat same steps for remaining schemes "TR and W2" and agents as per instruction.

upload_2017-2-13_0-25-23.png

and output get export next to MM and FS schemes output as shown in below pic
 

Attachments

  • upload_2017-2-13_0-17-27.png
    upload_2017-2-13_0-17-27.png
    56 KB · Views: 2
  • upload_2017-2-13_0-23-52.png
    upload_2017-2-13_0-23-52.png
    66.3 KB · Views: 0
  • upload_2017-2-13_0-31-6.png
    upload_2017-2-13_0-31-6.png
    115.2 KB · Views: 2
I didn't ask 'Do You eat ice cream?'
I don't want to know what clothes do You wear!
I don't need to know anything about Weather!
I tried to ask simply question.
I need answers, nothing more!
 
Why TWO TIMES headers? Focus!
If You send sample view of layout then it should look WANTED layout!
... and there were more questions! Focus!
 
upload_2017-2-13_0-35-46-png.38425
 
Okay
... as usual
I didn't eat Ice Cream today!
... #40 reply!
 

Attachments

  • ExceptionRates to be upload.xlsb
    48.3 KB · Views: 2
Yes, yes, yes ...
Screen Shot 2017-02-13 at 09.10.53.png
... and that 'output's layout was same as in Your original attachment
... or just delete those 'first double rows'
 
Did You try to look #43 reply?
It's looks as in #45 and #48 reply!
... and as below!
Screen Shot 2017-02-13 at 11.15.31.png
I didn't change output-sheet like above ''!
I can do it - no problem!
 
Back
Top