I know - VBA mode can be quite confusing.
Attached you will find my sheet, completely anonymized and without any controls. Right now it looks like the Word doc did. But it's hard work.
Have a look at it. If it's worth it, I will then open a new thread, but I can't imagine what could be done better and/or faster. Excel does not have comprehensive text formatting features - why should it ...
NP
|