re: Excel Help - Suggestions

Don't force the current tool to do what you need. Think outside the box. That data is coming to you in excel format from a database. They are using something such as SSIS or SSRS to create that. Discuss with the source of that data. Tell them your business need and how much time you waste formatting it how you need.

Let them create the right solution a d you both celebrate the value add opportunity and cost savings.