Excel to adjust the negative value with the positive value in a given criteria

[sriram170]

[TABLE="width: 626"]
<tbody>[TR]
[TD][TABLE="width: 289"]
<tbody>[TR]
[TD]GL[/TD]
[TD]CC[/TD]
[TD]Amount[/TD]
[TD]Project[/TD]
[TD]Comments[/TD]
[/TR]
[TR]
[TD="align: right"]164001[/TD]
[TD="align: right"]9311[/TD]
[TD] 500.00[/TD]
[TD="align: right"]12000155[/TD]
[TD]in progress[/TD]
[/TR]
[TR]
[TD="align: right"]164002[/TD]
[TD="align: right"]9311[/TD]
[TD] 800.00[/TD]
[TD="align: right"]12000156[/TD]
[TD]other rect[/TD]
[/TR]
[TR]
[TD="align: right"]164002[/TD]
[TD="align: right"]9311[/TD]
[TD] 500.00[/TD]
[TD="align: right"]12000157[/TD]
[TD]to iniate[/TD]
[/TR]
[TR]
[TD="align: right"]164002[/TD]
[TD="align: right"]9311[/TD]
[TD] 500.00[/TD]
[TD="align: right"]12000158[/TD]
[TD]go live[/TD]
[/TR]
[TR]
[TD="align: right"]164005[/TD]
[TD="align: right"]9311[/TD]
[TD] 500.00[/TD]
[TD="align: right"]12000159[/TD]
[TD]go live[/TD]
[/TR]
[TR]
[TD="align: right"]164001[/TD]
[TD="align: right"]9322[/TD]
[TD] 1,000.00[/TD]
[TD="align: right"]12000160[/TD]
[TD]in progress[/TD]
[/TR]
[TR]
[TD="align: right"]164002[/TD]
[TD="align: right"]9322[/TD]
[TD] 1,000.00[/TD]
[TD="align: right"]12000161[/TD]
[TD]other rect[/TD]
[/TR]
[TR]
[TD="align: right"]164004[/TD]
[TD="align: right"]9322[/TD]
[TD] (500.00)[/TD]
[TD="align: right"]12000162[/TD]
[TD]to iniate[/TD]
[/TR]
[TR]
[TD="align: right"]164004[/TD]
[TD="align: right"]9322[/TD]
[TD] 500.00[/TD]
[TD="align: right"]12000163[/TD]
[TD]go live[/TD]
[/TR]
[TR]
[TD="align: right"]164005[/TD]
[TD="align: right"]9322[/TD]
[TD] 1,000.00[/TD]
[TD="align: right"]12000164[/TD]
[TD]go live[/TD]
[/TR]
[TR]
[TD="align: right"]164001[/TD]
[TD="align: right"]9333[/TD]
[TD] 2,000.00[/TD]
[TD="align: right"]12000165[/TD]
[TD]in progress[/TD]
[/TR]
[TR]
[TD="align: right"]164002[/TD]
[TD="align: right"]9333[/TD]
[TD] 500.00[/TD]
[TD="align: right"]12000166[/TD]
[TD]other rect[/TD]
[/TR]
[TR]
[TD="align: right"]164003[/TD]
[TD="align: right"]9333[/TD]
[TD] (500.00)[/TD]
[TD="align: right"]12000167[/TD]
[TD]to iniate[/TD]
[/TR]
[TR]
[TD="align: right"]164003[/TD]
[TD="align: right"]9333[/TD]
[TD] 2,000.00[/TD]
[TD="align: right"]12000168[/TD]
[TD]go live[/TD]
[/TR]
[TR]
[TD="align: right"]164004[/TD]
[TD="align: right"]9333[/TD]
[TD] 2,000.00[/TD]
[TD="align: right"]12000169[/TD]
[TD]go live[/TD]
[/TR]
</tbody>[/TABLE]


hi
I have a list of data here which contains negative and positive numbers in a list of cc so I need the below steps to be done with macros with some criteria , please help me techs
Steps :
1
first it has to filter the each cc
2
then if it finds any negative number the it has to filter the corresponding GL
3
then it has to find any positive number in the filtered range with same Gl and cc
4
then if the positive number is greater than the negative number then it can adjust with it and delete the negative row but before that it has to copy both and negative row and the positive row I next sheet for reference and then it can do the adjustment, if the credit value is greater then it can be split and adjusted with positive values with criteria same gl and cc
5
if it cannot find any positive value with same gl and cc of negative value then it has to leave and go to next negative value and follow step 3
6
after all the adjust ment is done then in comments column has to be filtered with "to initiate" and "other rect" then again it should start from step1

Please let me know if u need more details example file attached in the following link :FCS doubt - Download - 4shared - sriram muthu[/TD]
[/TR]
</tbody>[/TABLE]