Automate Formating Autogenerated Weekly Report (Hide Columns, Sorting, etc.)

[hazay19]

Hello Group,

We have a number of excel reports that we pull from a centralized system every Monday. I have no way for them to modify the report to my group's preferences, so every week I do very simple, but time consuming things like hiding or deleting the same unused columns, sorting by a particular column, assigning the print area, changing the margins.

I consider myself to be a moderate Excel user, but am not sure what I would use to accomplish this (do I need to learn VBA?) I was told that a previous employee and advanced excel user would copy the raw data template into another excel file and click a button and all of these things would start happening behind the scenes and on the screen automatically and the reports would be generated in the way he wanted.

Any feedback or suggestions would be appreciated, even terms to search for, since searching for auto formating does not seem to result in my specific topic. Thank you very much in advance,

Hazay19

[rcm]

Try recording your actions into a macro and then just run the macro for the next report trimming...
you may also post a non sensitive sample so a macro can be written ad hoc

Your friend might be right, sometimnes the population of a template might be a good solution,,