move offsetting values
My first recommendation is that rather than move things to a different
worksheet, you first make a copy of the sheet, and then make a macro for each
sheet, one that deletes all items that net to zero, and the other to delete
all items that don't net to zero. Result will be the same, but easier to
code in my opinion.
I will try to come up with code for the macros and send it in a separate
reply if I have time.
Keith
"Don S" wrote:
Have data that looks like this
100-
100
100-
98-
98
97-
97-
97
Data will be sorted in descending absolute value order. If 2 lines offset,
need to move lines to another worksheet. If all matching lines on value do
not offset to zero, leave alone. THANKS for any help...
|