.
.
I need via VBA code using Arrays do the next thing:
.
Sheet1:
___A________B___________C_____D___
1|............................................Year 2003
2|Cod......Account................Debit....Credit
3|.10.......Cash...........................4
4|.14.......Inventory...................10
5|.20.......Accts. Pay................................2
6|.30.......Capital...................................12
7|..............TOTAL.....................14........14
Sheet2:
___A________B___________C_____D___
1|............................................Year 2004
2|Cod......Account................Debit....Credit
3|.11.......Bank...........................6
4|.14.......Inventory....................4
5|.16.......Fixed Assts.................18
6|.20.......Accts. Pay................................5
7|.30.......Capital...................................23
8|..............TOTAL.....................28........28
Result needed.
Sheet3:
___A________B___________C_____D________E______F____
1|............................................Year 2003.............Year 2004
2|Cod......Account................Debit....Credit........Debit....Credit
3|.10.......Cash...........................4
4|.11.......Bank.........................................................6
5|.14.......Inventory...................10............................4
6|.16.......Fixed Assts...............................................18
7|.20.......Accts. Pay................................2..............................5
8|.30.......Capital...................................12............................23
9|..............TOTAL.....................14........14..............28.........28
The result in Sheet3 will use the column “Cod.” as reference for consolidation.
I would appreciate if the code let me select a range for Sheet1 and Sheet2, cause the number of accounts will be different in each case.
A last favor, the result in Sheet3 will be sorted by column “Cod.”.
Thanks for the help..
.
.
.
I need via VBA code using Arrays do the next thing:
.
Sheet1:
___A________B___________C_____D___
1|............................................Year 2003
2|Cod......Account................Debit....Credit
3|.10.......Cash...........................4
4|.14.......Inventory...................10
5|.20.......Accts. Pay................................2
6|.30.......Capital...................................12
7|..............TOTAL.....................14........14
Sheet2:
___A________B___________C_____D___
1|............................................Year 2004
2|Cod......Account................Debit....Credit
3|.11.......Bank...........................6
4|.14.......Inventory....................4
5|.16.......Fixed Assts.................18
6|.20.......Accts. Pay................................5
7|.30.......Capital...................................23
8|..............TOTAL.....................28........28
Result needed.
Sheet3:
___A________B___________C_____D________E______F____
1|............................................Year 2003.............Year 2004
2|Cod......Account................Debit....Credit........Debit....Credit
3|.10.......Cash...........................4
4|.11.......Bank.........................................................6
5|.14.......Inventory...................10............................4
6|.16.......Fixed Assts...............................................18
7|.20.......Accts. Pay................................2..............................5
8|.30.......Capital...................................12............................23
9|..............TOTAL.....................14........14..............28.........28
The result in Sheet3 will use the column “Cod.” as reference for consolidation.
I would appreciate if the code let me select a range for Sheet1 and Sheet2, cause the number of accounts will be different in each case.
A last favor, the result in Sheet3 will be sorted by column “Cod.”.
Thanks for the help..
.
.