kvassell1987
New Member
- Joined
- Apr 3, 2019
- Messages
- 2
I have never created a macro in excel, and last night I was trying to and I created an IfBold Macro by reading on this website, however it did not really do I really needed to do. I would really appreciate any help I can get. I am this General Ledger Activity report that I need to convert to a different template to put into a new accounting system.
In the image below
thanks in Advance
<tbody>
</tbody>
In the image below
- The Account number in Column A is bold and this should have its own column, however it needs to be applied to each following row until you get to another account number etc. (1300.00, 1301.00, 1304.00)
- The Account description in column B is bold should also go to another column, and then applied to each following row until you get to a new account number. (PREPAID ADVERTISING, PREPAID BUSINESS LICENSE, PREPAID INSURANCE)
- The 2 rows with Total for Account and Beginning balance can be deleted.
- the unbolded data (I turned blue in mr excel) is the detail that goes along with the Account number and Account description.
- I copied from excel because I did not know how to add it any other way on this thread.
thanks in Advance
A | B | C | D | E | F |
1300.000 | PREPAID ADVERTISING | ||||
1/31/2019 | STD 1300 | 75.00 | 2019-01-0159 | JERC | |
1/31/2019 | STD 1300 | 100.00 | 2019-01-0159 | JERC | |
1/31/2019 | STD 1300 | 123.25 | 2019-01-0159 | JERC | |
1/31/2019 | STD 1300 | 124.00 | 2019-01-0159 | JERC | |
1/31/2019 | STD 1300 | 291.67 | 2019-01-0159 | JERC | |
1/31/2019 | PUBLICATIONS | 535.82 | 2019-01-0180 | APIV | |
Total for Account #1300.000 | 535.82 | 713.92 | |||
Beginning Balance 3,883.25 | Ending Balance 3,705.15 | Net Change -178.10 | |||
1301.000 | PREPAID BUSINESS LICENSES | ||||
1/31/2019 | STD 1301 | 27.93 | 2019-01-0160 | JERC | |
Total for Account #1301.000 | 0.00 | 27.93 | |||
Beginning Balance 111.72 | Ending Balance 83.79 | Net Change -27.93 | |||
1304.000 | PREPAID INSURANCE | ||||
1/1/2019 | RISK | 2,406.00 | 2019-01-0001 | APIV | |
1/24/2019 | HOTEL MGMT CO | 3,563.51 | 2019-01-0071 | APIV | |
1/31/2019 | HEALTH INSURANCE | 3,563.51 | 2019-01-0155 | JERC | |
1/31/2019 | STD 1304 | 1,116.75 | 2019-01-0161 | JERC | |
1/31/2019 | STD 1304 | 1,336.33 | 2019-01-0161 | JERC | |
Total for Account #1304.000 | 5,969.51 | 6,016.59 |
<tbody>
</tbody>