rharri1972
Board Regular
- Joined
- Nov 12, 2021
- Messages
- 132
- Office Version
- 2019
- Platform
- Windows
I really don't know if my thread title is confusing but i will try to explain what i am trying to accomplish.
Any help will be GREATLY appreciated!!!
I have a worksheet("REPORT")
When completed it is Subtotaled with each change in PRODUCT ID which is column E and the subtotal is listed in MRP QTY which is Column H.
So the line Product ID (whatever the product may be) Total is Bold but the subtotal is not.
Is there a way with vba to make the subtotal cell (column H) to look left to Column E and if that cell in same row includes the word Total to make the subtotal cell (in Column H )value change to bold?
Any help will be GREATLY appreciated!!!
I have a worksheet("REPORT")
When completed it is Subtotaled with each change in PRODUCT ID which is column E and the subtotal is listed in MRP QTY which is Column H.
So the line Product ID (whatever the product may be) Total is Bold but the subtotal is not.
Is there a way with vba to make the subtotal cell (column H) to look left to Column E and if that cell in same row includes the word Total to make the subtotal cell (in Column H )value change to bold?