Macro for bold items in an spreadsheet

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

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

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK
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 ??
 
Upvote 0

Forum statistics

Threads
1,223,227
Messages
6,170,848
Members
452,361
Latest member
d3ad3y3

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top