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
[TABLE="class: cms_table, width: 1279"]
<tbody>[TR]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]D[/TD]
[TD="align: center"]E[/TD]
[TD="align: center"]F[/TD]
[/TR]
[TR]
[TD]1300.000
[/TD]
[TD]PREPAID ADVERTISING[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1/31/2019[/TD]
[TD]STD 1300[/TD]
[TD][/TD]
[TD]75.00[/TD]
[TD]2019-01-0159[/TD]
[TD]JERC[/TD]
[/TR]
[TR]
[TD]1/31/2019[/TD]
[TD]STD 1300[/TD]
[TD][/TD]
[TD]100.00[/TD]
[TD]2019-01-0159[/TD]
[TD]JERC[/TD]
[/TR]
[TR]
[TD]1/31/2019[/TD]
[TD]STD 1300[/TD]
[TD][/TD]
[TD]123.25[/TD]
[TD]2019-01-0159[/TD]
[TD]JERC[/TD]
[/TR]
[TR]
[TD]1/31/2019[/TD]
[TD]STD 1300[/TD]
[TD][/TD]
[TD]124.00[/TD]
[TD]2019-01-0159[/TD]
[TD]JERC[/TD]
[/TR]
[TR]
[TD]1/31/2019[/TD]
[TD]STD 1300[/TD]
[TD][/TD]
[TD]291.67[/TD]
[TD]2019-01-0159[/TD]
[TD]JERC[/TD]
[/TR]
[TR]
[TD]1/31/2019[/TD]
[TD]PUBLICATIONS[/TD]
[TD]535.82[/TD]
[TD][/TD]
[TD]2019-01-0180[/TD]
[TD]APIV[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Total for Account #1300.000[/TD]
[TD][/TD]
[TD]535.82[/TD]
[TD]713.92[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Beginning Balance 3,883.25[/TD]
[TD][/TD]
[TD]Ending Balance 3,705.15[/TD]
[TD][/TD]
[TD]Net Change -178.10[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1301.000[/TD]
[TD]PREPAID BUSINESS LICENSES[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1/31/2019[/TD]
[TD]STD 1301[/TD]
[TD][/TD]
[TD]27.93[/TD]
[TD]2019-01-0160[/TD]
[TD]JERC[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Total for Account #1301.000[/TD]
[TD][/TD]
[TD]0.00[/TD]
[TD]27.93[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Beginning Balance 111.72[/TD]
[TD][/TD]
[TD]Ending Balance 83.79[/TD]
[TD][/TD]
[TD]Net Change -27.93[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1304.000[/TD]
[TD]PREPAID INSURANCE[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1/1/2019[/TD]
[TD]RISK[/TD]
[TD]2,406.00[/TD]
[TD][/TD]
[TD]2019-01-0001[/TD]
[TD]APIV[/TD]
[/TR]
[TR]
[TD]1/24/2019[/TD]
[TD]HOTEL MGMT CO[/TD]
[TD]3,563.51[/TD]
[TD][/TD]
[TD]2019-01-0071[/TD]
[TD]APIV[/TD]
[/TR]
[TR]
[TD]1/31/2019[/TD]
[TD]HEALTH INSURANCE[/TD]
[TD][/TD]
[TD]3,563.51[/TD]
[TD]2019-01-0155[/TD]
[TD]JERC[/TD]
[/TR]
[TR]
[TD]1/31/2019[/TD]
[TD]STD 1304[/TD]
[TD][/TD]
[TD]1,116.75[/TD]
[TD]2019-01-0161[/TD]
[TD]JERC[/TD]
[/TR]
[TR]
[TD]1/31/2019[/TD]
[TD]STD 1304[/TD]
[TD][/TD]
[TD]1,336.33[/TD]
[TD]2019-01-0161[/TD]
[TD]JERC[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #FAFAFA"]Total for Account #1304.000[/TD]
[TD="bgcolor: #FAFAFA"][/TD]
[TD="bgcolor: #FAFAFA"]5,969.51[/TD]
[TD="bgcolor: #FAFAFA"]6,016.59[/TD]
[/TR]
</tbody>[/TABLE]
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
[TABLE="class: cms_table, width: 1279"]
<tbody>[TR]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]D[/TD]
[TD="align: center"]E[/TD]
[TD="align: center"]F[/TD]
[/TR]
[TR]
[TD]1300.000
[/TD]
[TD]PREPAID ADVERTISING[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1/31/2019[/TD]
[TD]STD 1300[/TD]
[TD][/TD]
[TD]75.00[/TD]
[TD]2019-01-0159[/TD]
[TD]JERC[/TD]
[/TR]
[TR]
[TD]1/31/2019[/TD]
[TD]STD 1300[/TD]
[TD][/TD]
[TD]100.00[/TD]
[TD]2019-01-0159[/TD]
[TD]JERC[/TD]
[/TR]
[TR]
[TD]1/31/2019[/TD]
[TD]STD 1300[/TD]
[TD][/TD]
[TD]123.25[/TD]
[TD]2019-01-0159[/TD]
[TD]JERC[/TD]
[/TR]
[TR]
[TD]1/31/2019[/TD]
[TD]STD 1300[/TD]
[TD][/TD]
[TD]124.00[/TD]
[TD]2019-01-0159[/TD]
[TD]JERC[/TD]
[/TR]
[TR]
[TD]1/31/2019[/TD]
[TD]STD 1300[/TD]
[TD][/TD]
[TD]291.67[/TD]
[TD]2019-01-0159[/TD]
[TD]JERC[/TD]
[/TR]
[TR]
[TD]1/31/2019[/TD]
[TD]PUBLICATIONS[/TD]
[TD]535.82[/TD]
[TD][/TD]
[TD]2019-01-0180[/TD]
[TD]APIV[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Total for Account #1300.000[/TD]
[TD][/TD]
[TD]535.82[/TD]
[TD]713.92[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Beginning Balance 3,883.25[/TD]
[TD][/TD]
[TD]Ending Balance 3,705.15[/TD]
[TD][/TD]
[TD]Net Change -178.10[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1301.000[/TD]
[TD]PREPAID BUSINESS LICENSES[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1/31/2019[/TD]
[TD]STD 1301[/TD]
[TD][/TD]
[TD]27.93[/TD]
[TD]2019-01-0160[/TD]
[TD]JERC[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Total for Account #1301.000[/TD]
[TD][/TD]
[TD]0.00[/TD]
[TD]27.93[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Beginning Balance 111.72[/TD]
[TD][/TD]
[TD]Ending Balance 83.79[/TD]
[TD][/TD]
[TD]Net Change -27.93[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1304.000[/TD]
[TD]PREPAID INSURANCE[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1/1/2019[/TD]
[TD]RISK[/TD]
[TD]2,406.00[/TD]
[TD][/TD]
[TD]2019-01-0001[/TD]
[TD]APIV[/TD]
[/TR]
[TR]
[TD]1/24/2019[/TD]
[TD]HOTEL MGMT CO[/TD]
[TD]3,563.51[/TD]
[TD][/TD]
[TD]2019-01-0071[/TD]
[TD]APIV[/TD]
[/TR]
[TR]
[TD]1/31/2019[/TD]
[TD]HEALTH INSURANCE[/TD]
[TD][/TD]
[TD]3,563.51[/TD]
[TD]2019-01-0155[/TD]
[TD]JERC[/TD]
[/TR]
[TR]
[TD]1/31/2019[/TD]
[TD]STD 1304[/TD]
[TD][/TD]
[TD]1,116.75[/TD]
[TD]2019-01-0161[/TD]
[TD]JERC[/TD]
[/TR]
[TR]
[TD]1/31/2019[/TD]
[TD]STD 1304[/TD]
[TD][/TD]
[TD]1,336.33[/TD]
[TD]2019-01-0161[/TD]
[TD]JERC[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #FAFAFA"]Total for Account #1304.000[/TD]
[TD="bgcolor: #FAFAFA"][/TD]
[TD="bgcolor: #FAFAFA"]5,969.51[/TD]
[TD="bgcolor: #FAFAFA"]6,016.59[/TD]
[/TR]
</tbody>[/TABLE]