Hi magicians,
I have the below simplified table of what I'm working on.
I want to run a VBA to to delete rows where the sum of column B is zero for the same number in column A. E.g. for 1001 in column A, the sum of column B is zero, so these rows should be deleted and so forth leaving just two rows of 1003 for 100 each.
The current list I am working on has 50k+ lines, hence why a VBA would be needed.
Any ideas for a starting point would be greatly appreciated!
I have the below simplified table of what I'm working on.
I want to run a VBA to to delete rows where the sum of column B is zero for the same number in column A. E.g. for 1001 in column A, the sum of column B is zero, so these rows should be deleted and so forth leaving just two rows of 1003 for 100 each.
The current list I am working on has 50k+ lines, hence why a VBA would be needed.
Any ideas for a starting point would be greatly appreciated!