Help in Thinking Through Process

Hi, I have an Excel report that queries an SQL database to get data after which there is a lot of formatting and calculating that needs to be done. (They want pretty colors and lines and all sorts of formatting stuff.) There will be about 50 columns and there is a print range that prints only a portion of those columns.

My question is:

• would it be better to set up the query so that it brings in blank columns in the appropriate locations (where calculating needs to occur) and have the formatting all set up, just mainly coding the calculations through vba

or

• would it be better to just bring back the data and then add all the columns/calculations in the correct locations and do the formatting

They have changed their minds many times about what columns they want and where they want them, so by "better" I mean easier/cleaner code-wise to modify and faster performance.

When it's done, it lives in SharePoint and multiple people access and run it weekly.

Any thoughts/suggestions?
Thank you.

The latter. Adding formatting in VBA is drop-dead simple.