We have a worksheet in which column F (Break type) there is a need for formatting of text as below –
There are multiple names for the same break type for example Notional & Notional Break, IA & IA Break, MTM and MTM Break, Unmatched and Unmatched break, Legal and Legal Break on different rows, Hence I am looking to get everything on all the rows to same format for same break type - For example Rows reflecting Notional & Notional Break as different should be formatted as Notional Break, IA & IA Break should be formatted as IA Break, MTM and MTM Break as MTM Break, Unmatched and Unmatched Break as Unmatched Break, Legal, Legal difference and Legal break as Legal Break with the help of VBA macro.
Note- 1. Number of rows may differ on a daily basis.
2. in the Before workbook attached, the starting Characters in Column F might either be in lower case or upper case
3.Attached files that are before formatting and after formatting.
Bookmarks