Only way I can think of is to write a VBA program; it'll look at the widths of cols B and C and adjust them appropriately. You can run it periodically and manually, or maybe have it run automatically whenever you make any change to the worksheet—which way is better depends, I suppose, on how much work you do with that worksheet and what kind of changes. I'd say start it as a program you trigger manually, and decide later whether you want to turn t loose to be triggered by changes.
If you don't know how to create such a program, one of us can help, I'm sure :-).
Last edited by BobBridges; 04-11-2020 at 08:15 AM.
Reason: Should have added in the first place...
|