vba help - to make sumifs formula dynamic

[malleshg24]

Hi Team,


I have attached my Macro with Input File,
Macro gives correct result. but the code is not dynamic.

Need your help in creating Single custom Sumifs Formula , (Criteria ,sumranges and header, parameter should pass from Mapping sheet.)

I want result as per Mapping sheet, Macro will find header sum those headers range , as per cost center description.


I have taken few *Cost Center Description) as an example, list is lenghty, header to sum max there will be 4 headers.


Thanks in advance for your help.


mg