Excel macro to adjust negative value with positive value on a given criteria
GL CC Amount Project Comments
164001 9311 500.00 12000155 in progress
164002 9311 800.00 12000156 other rect
164002 9311 500.00 12000157 to iniate
164002 9311 500.00 12000158 go live
164005 9311 500.00 12000159 go live
164001 9322 1,000.00 12000160 in progress
164002 9322 1,000.00 12000161 other rect
164004 9322 (500.00) 12000162 to iniate
164004 9322 500.00 12000163 go live
164005 9322 1,000.00 12000164 go live
164001 9333 2,000.00 12000165 in progress
164002 9333 500.00 12000166 other rect
164003 9333 (500.00) 12000167 to iniate
164003 9333 2,000.00 12000168 go live
164004 9333 2,000.00 12000169 go live
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, and file is attached for reference
Attachment | Size |
---|---|
FCS doubt.xlsx | 10.56 KB |
Recent comments
5 years 34 weeks ago
6 years 20 weeks ago
6 years 32 weeks ago
6 years 35 weeks ago
6 years 36 weeks ago
6 years 42 weeks ago
6 years 50 weeks ago
6 years 50 weeks ago
6 years 50 weeks ago
6 years 50 weeks ago