Moving Bold items to other columns

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
ABCDEF
1300.000
PREPAID ADVERTISING
1/31/2019STD 130075.002019-01-0159JERC
1/31/2019STD 1300100.002019-01-0159JERC
1/31/2019STD 1300123.252019-01-0159JERC
1/31/2019STD 1300124.002019-01-0159JERC
1/31/2019STD 1300291.672019-01-0159JERC
1/31/2019PUBLICATIONS
535.822019-01-0180APIV
Total for Account #1300.000 535.82713.92
Beginning Balance 3,883.25Ending Balance 3,705.15Net Change -178.10
1301.000PREPAID BUSINESS LICENSES
1/31/2019STD 130127.932019-01-0160JERC
Total for Account #1301.000 0.0027.93
Beginning Balance 111.72Ending Balance 83.79Net Change -27.93
1304.000PREPAID INSURANCE
1/1/2019RISK
2,406.002019-01-0001APIV
1/24/2019HOTEL MGMT CO
3,563.512019-01-0071APIV
1/31/2019HEALTH INSURANCE
3,563.512019-01-0155JERC
1/31/2019STD 13041,116.752019-01-0161JERC
1/31/2019STD 13041,336.332019-01-0161JERC
Total for Account #1304.000 5,969.516,016.59

<tbody>
</tbody>
 
Last edited by a moderator:

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

Forum statistics

Threads
1,213,536
Messages
6,114,202
Members
448,554
Latest member
Gleisner2

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