How to do a macro for Payment Voucher, Cash Book, and Bank Checks/Cheques?

How to do a macro for Payment Voucher, Cash Book, and Bank Checks/Cheques?

I shall be much obliged if you guys could kindly help me using VBA codes or Macro to run the following.

1. I have worksheet named Payment Voucher in Book1.
1.1 Date in Cell G1
1.2 Name in Cell B4
1.3 Invoice amount in Cell B7
1.4 Amount in Number [1,450,000.38] in Cell F7

2. I hope that you guys could help me to do the following:-

2.1 When I key DATE in Cell G1 at Payment Voucher, DATE automatically appear in the following 2 worksheets.
2.1A) Cell A2 of worksheet Cash Book (Book2)
2.1B) Cell G1 of worksheet Bank Check (Book3)

2.2 When I key NAME in Cell B4 at Payment Voucher, NAME automatically appear in the following 2 worksheets.
2.2A) Cell C2 of worksheet Cash Book (Book2)
2.2B) Cell B4 of worksheet Bank Check (Book3)

2.3 When I key AMOUNT in Cell F7 at Payment Voucher, NUMBER automatically appear in the following 2 worksheets.
2.3.A) Cell E2 of worksheet Cash Book (Book2)
2.3.B) Cell F6 of worksheet Bank Check (Book3)
2.3.C) Cell B6 of worksheet Bank Check, Number in TEXT must appear like this: One Million Four Hundred Fifty Thousand And Cents Thirty Eight Only

Any suggestion and advice is highly welcomed and appreciated.

Thousand thanks in advance.

Susan

Originally Posted by Susan Soo

How to do a macro for Payment Voucher, Cash Book, and Bank Checks/Cheques?

I shall be much obliged if you guys could kindly help me using VBA codes or Macro to run the following.

1. I have worksheet named Payment Voucher in Book1.
1.1 Date in Cell G1
1.2 Name in Cell B4
1.3 Invoice amount in Cell B7
1.4 Amount in Number [1,450,000.38] in Cell F7

2. I hope that you guys could help me to do the following:-

2.1 When I key DATE in Cell G1 at Payment Voucher, DATE automatically appear in the following 2 worksheets.
2.1A) Cell A2 of worksheet Cash Book (Book2)
2.1B) Cell G1 of worksheet Bank Check (Book3)

2.2 When I key NAME in Cell B4 at Payment Voucher, NAME automatically appear in the following 2 worksheets.
2.2A) Cell C2 of worksheet Cash Book (Book2)
2.2B) Cell B4 of worksheet Bank Check (Book3)

2.3 When I key AMOUNT in Cell F7 at Payment Voucher, NUMBER automatically appear in the following 2 worksheets.
2.3.A) Cell E2 of worksheet Cash Book (Book2)
2.3.B) Cell F6 of worksheet Bank Check (Book3)
2.3.C) Cell B6 of worksheet Bank Check, Number in TEXT must appear like this: One Million Four Hundred Fifty Thousand And Cents Thirty Eight Only

Any suggestion and advice is highly welcomed and appreciated.

Thousand thanks in advance.

Susan

Hello Susan,

What you asking is actually very simple. You simply need to the corresponding worksheet cells to the Payment Voucher cells.
________________________________________________________________

Example To link the DATE from Book 1 Cell G1:

Book 1 Worksheet = "Payment Voucher"
Book 2 Worksheet = "Cash Book"
Book 3 Worksheet = "Bank Check"

1) First Open all 3 workbooks.

2) Switch to Book 2: Press ALT + W and Click on Book 2 in the Dropdown Menu

3) Select Cell A2 in Book 2. Type an equal sign "=" in the Formula Bar

4) Switch to Book 1: Press ALT + W and Click on Book 1 in the Dropdown Menu

5) Click Cell G1 in Book1. The reference appears in the Formula Bar and then
Switches you back to Book 2 Cell A2.

6) Switch to Book 3: Press ALT + W and Click on Book 3 in the Dropdown Menu

7) Select Cell G1 in Book 3. Type an equal sign "=" in the Formula Bar

8) Switch to Book 1: Press ALT + W and Click on Book 1 in the Dropdown Menu

9) Click Cell G1 in Book1. The reference appears in the Formula Bar and then
Switches you back to Book 3 Cell G1.
________________________________________________________________

Now whenever the date is changed on the Payment Voucher Worksheet, the other worksheets in the other 2 workbooks will update automatically. Just repeat the process for the other items in the other workbooks. If you have problems e-mail LeithRoss@aol.com

Sincerely,
Leith Ross