I shall be much obliged if you guys could kindly let me have a copy of the VBA codes or Macro to run the above and the following.
1)I have 4 data to key into a worksheet named Payment Voucher.
1.1 Date in Cell G1
1.2 Name in Cell B4
1.3 Invoice amount in Cell B7
1.4Amount in Number [120,223.45] in Cell F7
2) I hope that you guys could help me to do the following:-
2.1) When I key the date in Cell G1 at Payment Voucher, the date will automatically appear in the following 2 worksheets.
2.a) Cell A2 of worksheet Cash Book
2.b) Cell G1 of worksheet Bank Check
2.2) When I key the name in Cell B4 at Payment Voucher, the name will automatically appear in the following 2 worksheets.
2.2.a) Cell C2 of worksheet Cash Book
2.2.b) Cell B4 of worksheet Bank Check
2.3) When I key the amount in number in Cell F7 at Payment Voucher, the number will automatically appear in the following 2 worksheets.
2.3.a) Cell E2 of worksheet Cash Book
2.3.b) Cell F6 of worksheet Bank Check
2.3.c) Cell B6 of worksheet Bank Check, the number in text must be appeared like this " One Hundred Twenty Thousand And Two Hundred Twenty Three and Cents Forty Five Only "
Please take note that all the worksheets for Payment voucher, Cash Book and Bank Check are in different workbooks.
Any suggestion is most welcome.
Thanks in advance.