Help.
Mau narik data dari ending balance dec07 ke beginning balance jan08
beradasarkan nomor COA, gimana ya?
kasus di bawah:
Data file dec07
A B C D E F
1 COA Beginning Debit Credit Ending
Balance Balance
2 1220 Office Furniture 16,639,665 - - 16,639,665
3 1221 Office Equip. 12,949,515 - - 12,949,515
4 1222 Motor Vehicle 3,000,000 - - 3,000,000
Data file Jan08
A B C D E F
1 COA Beginning Debit Credit Ending
Balance Balance
2
3 1220 Office Furniture
4 1221 Office Equip.
5 1222 Motor Vehicle
dan untuk narik data dari ID COA yg sama di worksheet yg beda juga
gimana ya??harus satu2 isi rumusnya kah???
help.
thx,
ika
