Please accept my apology in advance, this is going to be a long post.
I have a large workbook which gets sent to our board of directors every month. The data is downloaded from our mainframe and compiled in a useful form by a macro. It has worked well for the past seven years, with...