Looking for Specific Value

[knnwndlm]

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

[knnwndlm]

Thank you Jay!