suresh7860
New Member
- Joined
- Jul 18, 2015
- Messages
- 48
Hi Experts
Good Evening!
I am doing a task of updating the data manually for each criteria in Column V (Exh Pos / REVAL+CIS+FX / REVAL-SPOT) by filtering Exh Pos then if the sum of the amount in column H (AUD/CNY/ INR/USD/EUR/GBP......... Etc will be 25-30 different currencies) is positive then it should update column N with P35800 & Column P with IP35800 or if negative then it should updated with A35800 & Column P with IA35800to but if it zero then no change.
For example below if i filter column v with Exh Pos and filter column AUD its coming sum is +25 then i should go and update all filtered spceial call until last row with in column N with P35800 & Column P with IP35800 and filter again with next currency i.e., CNY which is zero hence i will not make any changes...
I am doing this task for thousands of lines and for 25-30 currencies and for 3 or 5 criteria's and for different regions hence its taking too much of time to do would be helpful any one can help me with:
<tbody>
</tbody>
<colgroup><col width="64"></colgroup><tbody>
</tbody>
Thanks for your help!
Regards
Suresh
Good Evening!
I am doing a task of updating the data manually for each criteria in Column V (Exh Pos / REVAL+CIS+FX / REVAL-SPOT) by filtering Exh Pos then if the sum of the amount in column H (AUD/CNY/ INR/USD/EUR/GBP......... Etc will be 25-30 different currencies) is positive then it should update column N with P35800 & Column P with IP35800 or if negative then it should updated with A35800 & Column P with IA35800to but if it zero then no change.
For example below if i filter column v with Exh Pos and filter column AUD its coming sum is +25 then i should go and update all filtered spceial call until last row with in column N with P35800 & Column P with IP35800 and filter again with next currency i.e., CNY which is zero hence i will not make any changes...
I am doing this task for thousands of lines and for 25-30 currencies and for 3 or 5 criteria's and for different regions hence its taking too much of time to do would be helpful any one can help me with:
Column D | Column G |
<colgroup><col></colgroup><tbody> </tbody> | Column N | Column P | Column V | ||||||
6001 | AUD |
<colgroup><col></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> | ||||||
6002 | CNY |
<colgroup><col></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> | ||||||
6003 | INR |
<colgroup><col></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> | ||||||
6004 | USD |
<colgroup><col></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> | ||||||
6005 | EUR |
<colgroup><col></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> | ||||||
6006 | GBP |
<colgroup><col></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> | ||||||
6001 | AUD |
<colgroup><col></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> | ||||||
6002 | CNY |
<colgroup><col></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> | ||||||
6003 | INR |
<colgroup><col></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> | ||||||
6004 | USD |
<colgroup><col></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> | ||||||
6005 | EUR |
<colgroup><col></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> | ||||||
6006 | GBP |
<colgroup><col></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> | ||||||
6001 | AUD |
<colgroup><col></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> | ||||||
6002 | CNY |
<colgroup><col></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> | ||||||
6003 | INR |
<colgroup><col></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> | ||||||
6004 | USD |
<colgroup><col></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> | ||||||
6005 | EUR |
<colgroup><col></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> | ||||||
6006 | GBP |
<colgroup><col></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> | ||||||
6001 | AUD |
<colgroup><col></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> | REVAL+CIS+FX | ||||||
6002 | CNY |
<colgroup><col></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> | REVAL+CIS+FX | ||||||
6003 | INR |
<colgroup><col></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> | REVAL+CIS+FX | ||||||
6004 | USD |
<colgroup><col></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> | REVAL+CIS+FX | ||||||
6005 | EUR |
<colgroup><col></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> | REVAL+CIS+FX | ||||||
6006 | GBP |
<colgroup><col></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> | REVAL+CIS+FX | ||||||
6001 | AUD |
<colgroup><col></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> | ||||||
6002 | CNY |
<colgroup><col></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> | ||||||
6003 | INR |
<colgroup><col></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> | ||||||
6004 | USD |
<colgroup><col></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> | ||||||
6005 | EUR |
<colgroup><col></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> | ||||||
6006 | GBP |
<colgroup><col></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> | ||||||
6001 | AUD |
<colgroup><col></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> | ||||||
6002 | CNY |
<colgroup><col></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> | ||||||
6003 | INR |
<colgroup><col></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> | ||||||
6004 | USD |
<colgroup><col></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> | ||||||
6005 | EUR |
<colgroup><col></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> | ||||||
6006 | GBP |
<colgroup><col></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> |
<tbody>
</tbody>
REVAL+CIS+FX |
<colgroup><col width="64"></colgroup><tbody>
</tbody>
Thanks for your help!
Regards
Suresh