on 08-06-2015 7:06 PM
Dear Macro Lords,
Here is a 'simple' requirement
n is a number that can vary
If n = 1, current bucket cell should be no input allowed
if n = 2, Current + next bucket cell should be no input allowed
if n= 3, current + next + next bucket cell should be no input allowed
and so on
Anyone who can print stolen syntax in next hour will be generously rewarded.
Thanks
BS
Hi Borat
I am not the expert, but I think all depends upon the condition how you find the value N.
Once you find the value N and then select the key figure and put the next 3 iteration i.e. 3 buckets with no input allowed.
So whenever you have found N, then continue with out the statement CELL (1) for respective KF with 3 iterations. I hope this would solve your problem.
Please try and let me know if it help.
Thanks
Amol
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Amol
N is step 1 of the macro and that is a unique value for a MATLOC (prod-loc master) at any given point in time...stored as aux kf. The rest is step 2
I wrote some crude syntax that 'works; but the idea was to make use of counter(). I hard coded it step by step for now. literally converting the above into unique macro steps (IF, IF , IF .IF..BETWEEN.. ELSE.. END IF ) for now.
Thanks
BS
Thanks Amol,
Didn't try yet. This was needed for a demo and for now I just had to make it work. Let me try this at leisure sometime.
This one below is not the final one. it has more conditions like DET_LEVEL and ROUND and other conditions but this is roughly the idea. PLIFZ is planned delivery time from Prod-Loc master
Regards
BS
User | Count |
---|---|
12 | |
4 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.