vimal01234
New Member
- Joined
- Oct 8, 2014
- Messages
- 6
There is a situation for which I am looking for a solution
I receive a lot of data in an excel sheet, Let's say in column A and these are receipts(positive amount) and payments(negative amount) and these net to zero except few
I already use a macro which matches positive to negative for example if there is a positive 45.52 then it will match with -45.52, however, the problem arises when a positive match with a combination of data i.e 45.52 will match with 30+10+5.52 or vice-versa
I am looking for a Macro which can identify these combinations of amounts and show these amounts separate or highlight them with a color..which I can later sort accordingly or anything else which will be easier for anyone to identify.
it would be helpful if I can make a macro which is able to solve a situation like this.
Thanks in advance.
I receive a lot of data in an excel sheet, Let's say in column A and these are receipts(positive amount) and payments(negative amount) and these net to zero except few
I already use a macro which matches positive to negative for example if there is a positive 45.52 then it will match with -45.52, however, the problem arises when a positive match with a combination of data i.e 45.52 will match with 30+10+5.52 or vice-versa
I am looking for a Macro which can identify these combinations of amounts and show these amounts separate or highlight them with a color..which I can later sort accordingly or anything else which will be easier for anyone to identify.
it would be helpful if I can make a macro which is able to solve a situation like this.
Thanks in advance.
