I do 11 reports at month-end. They all have the exact same field names and number of columns. Each contains 150 columns currently. However, at month-end I have to add 14 additional columns. Then for several existing columns I have to change the field names. For instance, the column name "Aug'13-Sep'13" turns into "Aug'13-Oct'13". I run a macro every month and use it on all 11 reports. However, the macro becomes useless when the next month-end period rolls along. In other words, the macro is so big that it can't be updated and used again. The process of recording the macro takes several hours and it's only good for 30 days...any suggestions on smarter approaches would be kindly appreciated. Much respect.
Last edited:
