Hello,
I am trying to create a macro that does the following:
<tbody>
</tbody>
Each category has a different amount of transactions each month. Any help would be great with this code. Thank you in advance!
I am trying to create a macro that does the following:
- Loop down sheet and copy the Description (Column E) Ex: Copy "Cash in Bank" [Note: the empty cells at the category description level (Beg and End)]
- Paste the description in (Column L) next to each transaction Ex: Paste "Cash in Bank" in cells L3 and L4
- Continue loop until end of sheet, which can be 1000+ transactions and with multiple categories
Property | Property Name | Date | Period | Description | Control | Reference | Debit | Credit | Balance | Remarks | Category |
1120-2450 | Cash in Bank | 100 | = Beginning Balance = | ||||||||
101st | 101 Street | 3/1/2019 | Mar 2019 | Bank of Excel | 56465 | 564654 | 0 | 5 | 105 | Loan#123 | (Cell L3) |
wall4 | 123 Wall St | 3/19/2019 | Mar 2019 | Bank of Excel | 8794 | 13812 | 0 | 10 | 115 | Inv# 456 | (Cell L4) |
Net Change = 20 | 0 | 15 | 115 | = Ending Balance = | |||||||
1115-0000 | Utility Deposits | 20.00 | = Beginning Balance = | ||||||||
104th | 104th street | 3/22/2019 | mar 2019 | The Gas Company | 576841 | 135451 | 0 | 5 | 25 | CheckScan #2001 | |
50ths | 50th street | 3/8/2019 | mar 2019 | The Gas Company | 484132 | 1568412 | 0 | 5 | 30 | 454654 | |
Net Change = 5 | 0 | 10 | 30 | = Ending Balance = |
<tbody>
</tbody>
Each category has a different amount of transactions each month. Any help would be great with this code. Thank you in advance!