Hi SME,
I have a Batch Macro that allocates the negative value into the positive value(s) within the same Tile. What I want to create is an Iterative Macro inside the Batch Macro to **bleep** out those line items within the same tile that have the same value but opposite signs (see highlighted rows in the attached file). In other words, I want to zero out those line items so that I won't have to allocate to the line items that contain the same values with the opposite sign.
Not sure if I can create an Iterative Macro inside a Batch Macro. If so, not sure how to approach this. Any suggestions?
Thanks,
kwl
