W
WooK
How to make a macro who will decrease number in a cell in column C
(Worksheet 1) for amount of cell in column C (Worksheet 2) depending on code
(column B Worksheet 2) and (column A Worksheet 1)
-----------------------
Before:
Worksheet 1:
A B C D
1 100 aaaaaaaaaaaa 5 GGG
2 101 BBBBBBBB 6 GGG
3 102 CCCCCCCC 10 GGG
4 103 DDDDDDDD 3 GGG
5 104 EEEEEEEEEE 2 GGG
Worksheet 2:
A B C D
1 1. 102 1 xxxxx
2 2. 103 2 xxxxx
----------------
After:
Worksheet 1:
A B C D
1 100 aaaaaaaaaaaa 5 GGG
2 101 BBBBBBBB 6 GGG
3 102 CCCCCCCC 9 GGG
4 103 DDDDDDDD 1 GGG
5 104 EEEEEEEEEE 2 GGG
(Worksheet 1) for amount of cell in column C (Worksheet 2) depending on code
(column B Worksheet 2) and (column A Worksheet 1)
-----------------------
Before:
Worksheet 1:
A B C D
1 100 aaaaaaaaaaaa 5 GGG
2 101 BBBBBBBB 6 GGG
3 102 CCCCCCCC 10 GGG
4 103 DDDDDDDD 3 GGG
5 104 EEEEEEEEEE 2 GGG
Worksheet 2:
A B C D
1 1. 102 1 xxxxx
2 2. 103 2 xxxxx
----------------
After:
Worksheet 1:
A B C D
1 100 aaaaaaaaaaaa 5 GGG
2 101 BBBBBBBB 6 GGG
3 102 CCCCCCCC 9 GGG
4 103 DDDDDDDD 1 GGG
5 104 EEEEEEEEEE 2 GGG