Having resolved my first problem, I am now struggling to tidy up my consolidation sheet. In essence I am looking to fill the columns and rows alongside the data as well as the sells either side of the title block. I have added a screen shot which may assist in explanation. The number of columns does not change, however the number of rows do, dependant on how many sub reports are pulled into this sheet. I can (obviously) do this long hand but am looking to automate for speed and because the report will be used by others who are less competent on VBA than me (believe me that's not difficult). Would appreciate any guidance n how to achieve this.


Report.jpg