MarcoSpring
New Member
- Joined
- Mar 22, 2012
- Messages
- 16
Hi All
Here is my question.
I have a table with Country codes (Column) and Expenses (Row) in Sheet 1
I have a similar table in Sheet 2,
However, the country and Expense codes are not in order and sequence.
In Sheet 2, (let say B2) what formula should I be using in order to copy the figures from Sheet 1.
(I only show few rows of expenses).
<tbody>
</tbody>
Here is my question.
I have a table with Country codes (Column) and Expenses (Row) in Sheet 1
I have a similar table in Sheet 2,
However, the country and Expense codes are not in order and sequence.
In Sheet 2, (let say B2) what formula should I be using in order to copy the figures from Sheet 1.
(I only show few rows of expenses).
A | B | C | D | E | F | G | H | I | |||||||||
1 | GL Codes | INDIA | VIET | SPORE | HK | INDO | CHINA | MSIA | |||||||||
2 |
<tbody> </tbody><colgroup><col></colgroup> |
<tbody> </tbody><colgroup><col></colgroup> |
<tbody> </tbody><colgroup><col></colgroup> |
<tbody> </tbody><colgroup><col></colgroup> |
<tbody> </tbody><colgroup><col></colgroup> |
<tbody> </tbody><colgroup><col></colgroup> |
<tbody> </tbody><colgroup><col></colgroup> |
<tbody> </tbody><colgroup><col></colgroup> | |||||||||
3 |
<tbody> </tbody><colgroup><col></colgroup> |
<tbody> </tbody><colgroup><col></colgroup> |
<tbody> </tbody><colgroup><col></colgroup> |
<tbody> </tbody><colgroup><col></colgroup> | 40.00 |
<tbody> </tbody><colgroup><col></colgroup> | 50.00 | 50.00 | |||||||||
4 |
<tbody> </tbody><colgroup><col></colgroup> |
<tbody> </tbody><colgroup><col></colgroup> | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
<tbody> </tbody><colgroup><col></colgroup> | |||||||||
5 |
<tbody> </tbody><colgroup><col></colgroup> |
<tbody> </tbody><colgroup><col></colgroup> |
<tbody> </tbody><colgroup><col></colgroup> |
<tbody> </tbody><colgroup><col></colgroup> |
<tbody> </tbody><colgroup><col></colgroup> |
<tbody> </tbody><colgroup><col></colgroup> |
<tbody> </tbody><colgroup><col></colgroup> | 0.00 | |||||||||
6 |
<tbody> </tbody><colgroup><col></colgroup> |
<tbody> </tbody><colgroup><col></colgroup> |
<tbody> </tbody><colgroup><col></colgroup> | 400.00 |
<tbody> </tbody><colgroup><col></colgroup> | 500.00 | 50.00 | 350.00 | |||||||||
7 |
<tbody> </tbody><colgroup><col></colgroup> |
<tbody> </tbody><colgroup><col></colgroup> |
<tbody> </tbody><colgroup><col></colgroup> | 50.00 |
<tbody> </tbody><colgroup><col></colgroup> | 30.00 | 50.00 | 60.00 | |||||||||
SHEET 1 | |||||||||||||||||
A | B | C | D | E | F | G | H | ||||||||||
1 | GL Codes | CHINA | INDIA | HK | MSIA | SPORE | VIET | INDO | |||||||||
2 | 601 - LOCAL SALES | Formula? | |||||||||||||||
3 | 602 - OVERSEA SALES | ||||||||||||||||
4 | |||||||||||||||||
5 | 702 - UTILITIES | ||||||||||||||||
6 | 701 - RENTALS | ||||||||||||||||
7 | |||||||||||||||||
8 | 501 - BANK CHARGES | ||||||||||||||||
9 | 502 - ADMIN CHARGES | ||||||||||||||||
SHEET 2 | |||||||||||||||||
<tbody>
</tbody>