sintek,

Yes the columns that are in the example file will stay the same for every report. What changes is everything in those columns. As you can see in the file, sometimes there are salespeople listed in the salesperson 3 field when salesperson 1, 2 and 4 are empty. This is not something we are able to change in SalesForce because of how everything was set up years ago. Some salespeople have business names. The data does not need to start in row 6 for the headings. That is just how the macro is set up. If it makes it easier to have the copying and pasting of the report in a new tab with the headings on the first row and have the macros on a separate tab then that would be fine too. Does that answer your question?