I have the following data:
I would like to generate the following result with the same format bold and freeze pane for line 1 and green filled color and bold letter for last line:
I am aware that I could do this trough a pivot table however I need to perform this action frequently so I would like to have a vba combined with a pivot table if necessary to generate this result.
Due to the fact that this is just a template which means that Query count Contributor and Week columns can be in different position I would like to have a config sheet In which I specified where are the columns concerned.
Instead of changing the code I will just need to modify the Config sheet.
If the Column of Config sheet should be reported in numbers, this is fine with me.
Please find attached the xlsm file.
Thank you again for your help.