Macro for bold items in an spreadsheet

[kvassell1987]

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

• 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>

 

[Michael M]

Ok, can you post the IfBold macro that you created ?
Is the data you posted above the way it appeared AFTER your IfBold macro was used or BEFORE ??