RAJESH1960
Banned for repeated rules violations
- Joined
- Mar 26, 2020
- Messages
- 2,313
- Office Version
- 2019
- Platform
- Windows
Hello guys
I am trying to add a code in the beginning of the already existing code. I have 2 steps to write. I am not able to record the below with the help of a macro and to write the code is too complicated for me. Need help to understand and write the code.
I am trying to add a code in the beginning of the already existing code. I have 2 steps to write. I am not able to record the below with the help of a macro and to write the code is too complicated for me. Need help to understand and write the code.
- select the column C and replace “(as per details)” with the name in cell K1.
- In column G my application won’t work if the voucher numbers are same. So, I want to give the voucher numbers in the series of 1001 to as many vouchers are there in the sheet. In this case there are 11 vouchers. They have to be replaced with 1001 to 1011.
Test Multiple voucher workings.xlsx | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | |||
1 | W Test Purchases | Kotak Mahindra Bank | ||||||||||||
2 | Kotak Mahindra Bank Book | |||||||||||||
3 | ||||||||||||||
4 | ||||||||||||||
5 | 1-Apr-2021 to 14-Jul-2021 | |||||||||||||
6 | Date | Particulars | Vch Type | Vch No. | Debit | Credit | ||||||||
7 | 01-07-2021 | Cr | (as per details) | Receipt | 1 | 4040.00 | ||||||||
8 | Sunday | 1015.00 Cr | ||||||||||||
9 | Monday | 2025.00 Cr | ||||||||||||
10 | Tuesday | 1000.50 Cr | ||||||||||||
11 | Round Off | 0.50 Dr | ||||||||||||
12 | 01-07-2021 | Dr | (as per details) | Payment | 1 | 1001.00 | ||||||||
13 | January | 100.00 Dr | ||||||||||||
14 | February | 200.00 Dr | ||||||||||||
15 | March | 300.00 Dr | ||||||||||||
16 | April | 400.00 Dr | ||||||||||||
17 | Round Off | 1.00 Dr | ||||||||||||
18 | 02-07-2021 | Cr | (as per details) | Receipt | 2 | 4040.00 | ||||||||
19 | Sunday | 1015.00 Cr | ||||||||||||
20 | Monday | 2025.00 Cr | ||||||||||||
21 | Tuesday | 1000.50 Cr | ||||||||||||
22 | Round Off | 0.50 Dr | ||||||||||||
23 | 03-07-2021 | Dr | (as per details) | Payment | 2 | 1001.00 | ||||||||
24 | January | 100.00 Dr | ||||||||||||
25 | February | 200.00 Dr | ||||||||||||
26 | March | 300.00 Dr | ||||||||||||
27 | April | 400.00 Dr | ||||||||||||
28 | Round Off | 1.00 Dr | ||||||||||||
29 | 04-07-2021 | Dr | (as per details) | Payment | 3 | 1001.00 | ||||||||
30 | January | 100.00 Dr | ||||||||||||
31 | February | 200.00 Dr | ||||||||||||
32 | March | 300.00 Dr | ||||||||||||
33 | April | 400.00 Dr | ||||||||||||
34 | Round Off | 1.00 Dr | ||||||||||||
35 | 05-07-2021 | Cr | (as per details) | Receipt | 3 | 4040.00 | ||||||||
36 | Sunday | 1015.00 Cr | ||||||||||||
37 | Monday | 2025.00 Cr | ||||||||||||
38 | Tuesday | 1000.50 Cr | ||||||||||||
39 | Round Off | 0.50 Dr | ||||||||||||
40 | 06-07-2021 | Cr | Cash | Contra | 1 | 1000.00 | ||||||||
41 | 06-07-2021 | Dr | Cash | Contra | 2 | 2000.00 | ||||||||
42 | 09-07-2021 | Dr | (as per details) | Payment | 8 | 1001.00 | ||||||||
43 | January | 100.00 Dr | ||||||||||||
44 | February | 200.00 Dr | ||||||||||||
45 | March | 300.00 Dr | ||||||||||||
46 | April | 400.00 Dr | ||||||||||||
47 | Round Off | 1.00 Dr | ||||||||||||
48 | 14-07-2021 | Dr | Cash | Contra | 3 | 2000.00 | ||||||||
49 | 14-07-2021 | Cr | Cash | Contra | 4 | 1000.00 | ||||||||
50 | 14120.00 | 8004.00 | ||||||||||||
51 | Dr | Closing Balance | 6116.00 | |||||||||||
52 | 14120.00 | 14120.00 | ||||||||||||
Bank 5 |