on 12-21-2012 5:34 AM
Hi Gurus,
I have to create a macro which will not save the values if condition fails at Level 2 , screen shot is also attached. I am able to make the cell Red and information displayed but the problem is its saves the data....can anybody help on this....
Macros in the Macro Book
New macro
IF
New condition
Cell: SM Budget ( M 01.2013 )
>
Cell: HO Budget ( M 01.2013 )
New step : ( 1 Iterations : M 01.2013; M 01.2013 )
Row: SM Budget ( Attributes ) =
CELL_BG( 6 )
Error [ DSSS ]
ENDIF
Hi,
Once you write in the cell, data will be written to livecache. To prevent this, you can
compute in an auxiliary row, copy to final ratio after you pass some IF logic.
Thanks,
J
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
13 | |
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.